Installation:Ubuntu:MySQL
From PMWH2 - PHPMyWebHosting's official wiki
On Ubuntu 7.10 Server you need to install the following packages:
- mysql-server
On Debian GNU/Linux use this command to install all at once:
apt-get install mysql-server libmysqlclient15-dev
Now we need the database and a user for accessing the database through postfix and courier:
bash #> mysql -u root -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.45-Debian_1ubuntu3.1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE database pmwh2; Query OK, 1 row affected (0.00 sec) mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, RELOAD ON *.* TO 'pmwh2'@'localhost' identified by "pmwh-password" WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
MySQL setup is done for now. next step