This is a short an simple tutorial on how to enable remote access on MySQL on Ubuntu/Debian:
- Edit the file /etc/mysql/my.cnf: at the line with: bind-address = …
- Replace 127.0.0.1 with your server’s IP address.
- Save the file!!!
- Log in to MySQL: mysql -u root -p