Open MySQL for remote access

To see all users:

SELECT User, Host, Password FROM mysql.user;

To open for remote access, set up an appropriate user:

CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;

Edit the configuration file my.cnf (in /etc/mysql) and set property:

bind-address = [server-address]

Leave a Reply

Your email address will not be published. Required fields are marked *