Connect SequelPro to a remote mysql server

09th Nov, 2012 | mysql

First alter /etc/mysql/my.cnf and comment out the line:

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

#bind-address = 127.0.0.1

This enables remote connections. Now we need to create a user to receive the remote connection. In the mysql shell:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Job done!