linux poison RSS
linux poison Email

Installation and Configuration of MySQL in Ubuntu

To install MySQL, run the following command from a terminal prompt:
sudo apt-get install mysql-server

During the installation process you will be prompted to enter a password for the MySQL root user.

Once the installation is complete, restart the MySQL server: sudo /etc/init.d/mysql restart
Check if MySQL is running: sudo netstat -tap | grep mysql
you should see the following line or something similar:

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

Configuration

You can edit the /etc/mysql/my.cnf file to configure the basic settings -- log file, port number, etc. For example, to configure MySQL to listen for connections from network hosts, change the bind_address directive to the server's IP address:

bind-address = 192.168.0.5

[Note] Replace 192.168.0.5 with the appropriate address.

After making a change to /etc/mysql/my.cnf the mysql daemon will need to be restarted:

sudo /etc/init.d/mysql restart


0 comments:

Post a Comment

Related Posts with Thumbnails