Setup Remote MySQL Server (SRMS)



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.


Post a Comment

Previous Next

نموذج الاتصال