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
After making a change to
/etc/mysql/my.cnf the mysql daemon will need to be restarted: sudo /etc/init.d/mysql restart
If you would like to change the MySQL root password, in a terminal enter:
sudo dpkg-reconfigure mysql-server-5.1
The mysql daemon will be stopped, and you will be prompted to enter a new password.
Ref: https://help.ubuntu.com/10.04/serverguide/C/mysql.html
No comments:
Post a Comment