AVAILABLE: 5
To allow remote access to MySQL, you need to comment out the bind-address
(you've done this) and enable networking in the configuration file.
Next, ensure the user is granted remote access. Check your users with the following command:
SELECT User, Host FROM mysql.user;
If your user has 127.0.0.1
or localhost
listed as the host, remote access is not enabled. Update it as follows:
UPDATE mysql.user SET Host='%' WHERE User='__here_your_username';
Grant privileges:
FLUSH PRIVILEGES;
The %
symbol is a wildcard for "all hosts."
That's it! You can now log in using your favorite MySQL manager. Personally, I use DBeaver.