On Gentoo GNU/Linux you need to install the following packages:
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.