Remote access to MySQL for a none-root user

First step:

MAKE SURE YOU TRUST THEM

Next Step:

edit /etc/mysql/my.cnf change this line (if it exists)

bind-address            = 127.0.0.1

To this:

#bind-address            = 127.0.0.1

restart MySQL:

service mysql restart

add rule in the firewall:

ufw allow from any to any port 3306

Finally, grant them access in MySQL. This example assumes the user is “remote_user”, the password is “remote_password” and database is “local_db”. Change to match what you need. If you need full access:

GRANT ALL PRIVILEGES ON local_db.* to 'remote_user'@'%' IDENTIFIED BY 'remote_password'; FLUSH PRIVILEGES;

For most rights, but not full rights:

GRANT SELECT,UPDATE,INSERT ON local_db.* to 'remote_user'@'%' IDENTIFIED BY 'remote_password'; FLUSH PRIVILEGES;

For Read-Only:

GRANT SELECT ON local_db.* to 'remote_user'@'%' IDENTIFIED BY 'remote_password'; FLUSH PRIVILEGES;