Installation:Ubuntu:MySQL

From PMWH2 - PHPMyWebHosting's official wiki
Jump to: navigation, search
up

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