Install MySQL 5.1 During installation, specify a password for the root user. I was also prompted to configure Postfix, and selected the "No configuration" option. Allow Remote Access to the MySQL Server First of all, have to tell MySQL to listen to traffic coming from places other than 127.0.0.1. this is done by editing the file at /etc/mysql/my.cnf. Adjust the following line: Allow a Specific User Remote Access MySQL requires that remote access users be specifically appointed. Issue the following command: You'll be prompted for the root MySQL user's password. After entering it, hit enter, and you'll be in the mysql console with a "mysql>" prompt. Enter the following two lines: This means that if user "root" connects from the given IP address using the password you've specified, that user will have full privileges on all databases. apt-get install mysql-server-5.1 bind-address 0.0.0.0 # this was 127.0.0.1 mysql -u root -p grant all privileges on *.* to 'root'@'[the ip address you'll be connecting from]'
identified by '[password]';