Topic: mysql password

[pippin]

is it the same password as admin,root?

i am setting up a forum and cant get into the database with the password for admin,root

so the result is that i cant install unless i use /usr/bin/mysqladmin -u root password 123456789

But then i cant log in to my database and create a new  

[cactus]

is it the same password as admin,root?

i am setting up a forum and cant get into the database with the password for admin,root

so the result is that i cant install unless i use /usr/bin/mysqladmin -u root password 123456789

But then i cant log in to my database and create a new  

Never and I mean really never change your MySQL root password, this is used internally in the SME Server.

If you login at your server you can access the mysql client with the root account without a password, this account only works locally. With this account you can create a new account with the proper privileges to access your server (see the mysql manual for this).

If this user has to login from a remote machine you will have to change your mysql configuration to have it accept connections at a port as it is default configured to use a socket. I don't know to do this by heart, but it has been explained on the forums several times, please use the search funtion.

[pippin]

Well if i try to install a forum i do it locally Or am i wrong

[pfloor]

Cactus is correct...NEVER mess with the root password.  It is 72 characters long and you don't need to know what it is or ever have to use it.

To install a forum, do the following:

Log into mysql. No password is required, just type mysql at the command line.
Create a NEW database for your forum.
Create a NEW user with appropriate permissions for access to the new database.

Use the new database and user you just created in your new forum during the forum setup.

[pippin]

How do you do that?
I am newbee on databases and mysql

[Boris]

>>I am newbee on databases and mysql <<

Install phpmyadmin contrib for your SME (found here on this site). This would be great help for managing your MySQL.

[cactus]

How do you do that?
I am newbee on databases and mysql

[list=1]

• Log in to your server on the console or over ssh
• Open mysql by typing
  Code: [Select]
  mysql
• Create a new database:
  Code: [Select]
  create database dbname
• Grant the neccesarry priviliges to a user:
  Code: [Select]
  grant select, .... on dbname.* to user@host identified by'password';(Mind the quotes around the password)[/list:o]
  All this can be found on the internet using google as well as in the mysql manual. A mysql/database tutorial on the internet is a good idea to start with I think, a lot can be found using google.
  
  Good luck!

[pfloor]

>>I am newbee on databases and mysql <<

Install phpmyadmin contrib for your SME (found here on this site). This would be great help for managing your MySQL.

CAUTION!!! phpmyadmin gives you unrestricted root privileges to mysql and will allow you (and make it VERY EASY) to change the mysql root password.  MANY people (even experienced users) have done this either on purpose or by accident.

DO NOT CHANGE THE MYSQL ROOT PASSWORD!!!

phpmyadmin can be used to do things to your mysql databases that should not be done.  DON'T take this tool lightly.

It is an extremely powerful tool and may be very useful if you need to administer your databases all the time.  If you just want to create a database and user or 2, just do it manually as cactus indicates.

[pippin]

as i said i am newbee and havent the clue what to do to make a new user

Someone have to point me in the right direction and explain in details how to do it

[pfloor]

Here is a how-to on how to install phpbb on sme5X.  It still applies to 7X.  

http://no.longer.valid/phpwiki/index.php/How%20to%20set%20up%20phpBB%202.0.0%20on%20SME%20Server%205.0%20or%205.1.2

An excerpt from the how-to on how to create a database and user

You're almost ready to configure phpBB.  If you don't have a current installation, you'll need to create a database and database user for phpBB before you proceed.  Note that you can (and should) change "phpbbpassword" below to some other password:

[root@test httpd.conf]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.36

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> CREATE DATABASE phpbb;
Query OK, 1 row affected (0.10 sec)

mysql> GRANT ALL PRIVILEGES ON phpbb.* TO phpbbadmin@localhost IDENTIFIED BY 'phpbbpassword';
Query OK, 0 rows affected (0.16 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.06 sec)

mysql> quit
Bye

There are many how-to's and documentation on this site.  The search box in the upper-left-hand corner is your friend.