Mysql Setup

Make sure you have all the following lines need to uncomment somewhere in your apache2.conf (or in your conf.d/php.ini) file:

So this becomes

The configuration file of mysql is located at: /etc/mysql/my.cnf

By default mysql creates user as root and runs with no password. To change Root Password

mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
To Create User

To access the mySQL database from PHP script, you must never use the root password, you need to create a user for that purpose. Alternatively you can add users to mysql database by using a control panel like phpMyAdmin to easily create or assign database permission to users.

To access the web interface type the following in you web browser and enter:


When it prompts for username and password enter the database root as username and enter the password (By default there is no password for database root user)


Content last revised 14/08/2010 0100 UTC