MySQL

 

+

Search Tips   |   Advanced Search

 

Installation

To install MySQL...

sudo apt-get install mysql-server mysql-client

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

sudo netstat -tap | grep mysql

You should see the following line...

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

If the server is not running correctly, to start...

sudo /etc/init.d/mysql restart

 

Configuration

Once MySQL is installed, configure the MySQL administrator password...

sudo mysqladmin -u root password newrootsqlpassword
sudo mysqladmin -p -u root -h localhost password newrootsqlpassword

You can edit...

/etc/mysql/my.cnf

...to configure the basic settings -- log file, port number, etc...