Install MySQL in Ubuntu9.10

To install MySQL under Ubuntu9.10, you can run the following command at the terminal prompt: sudoapt-getinstallmysql-serversudoapt-getinstallmysql-clientsudoapt-getinstallphp5-mysql // The installation php5-mysql is to connect php and mysql once the installation is complete, the MySQL server should be started automatically.

To install MySQL in Ubuntu 9.10, run the following command at a terminal prompt:

Sudo apt-get install mysql-server

Sudo apt-get install mysql-client

Sudo apt-get install php5-mysql // The installation php5-mysql is to connect php to mysql

Once the installation is complete, the MySQL server should be started automatically.

You can run the following command at a terminal prompt to check whether the MySQL server is running:

Sudo netstat-tap | grep mysql

When you run this command, you can see a line similar to the following:

Tcp 0 0 localhost. localdomain: mysql *: * LISTEN-

If the server cannot run properly, run the following command to start it:

Sudo/etc/init. d/mysql restart

Go to mysql

Mysql-uroot-p

(-U followed by username-p followed by password)

(Enter the mysql root Password)

Configure the MySQL administrator password:

Sudo mysqladmin-u root password newpassword