Installation:Gentoo:MySQL

up

On Gentoo GNU/Linux you need to install the following packages:

• dev-db/mysql
• dev-db/mysql-administrator

On Gentoo GNU/Linux use this command to install all at once:

machine root # emerge dev-db/mysql dev-db/mysql-administrator

Once this finishes, run the following command to set the mysql daemon to start automatically.

machine root # rc-update add mysql default

Then run the following command to start the service:

machine root # /etc/init.d/mysql start

First, change the password for root:

machine root # mysqladmin -u root flush-privileges password "password"

After that test if the new password works:

machine root # mysql -u root -p
Enter password: password
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.22

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

mysql> exit
Bye

Now that the password is set correctly we need to setup the database and a user for phpmywebhosting to use:

machine root # mysql -u root -p 
Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 32 to server version: 4.0.22

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

mysql> CREATE database [database name, e.g. pmwh];
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES on [database name].* to [postfix username, e.g. pmwh_user]@localhost identified by "[another secret here]";
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

MySQL setup is done for now.