Episode 19 – How To Enable Remote Access To MySQL Server on Windows Server

Problem:

You were asked to install and configure MySQL server on a Windows Server machine and need to provide remote access to it for your group to configure and manager when you are not around 🙂

Solution:

When you have completed the installation of the MySQL into the server. You can run this command:

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';

Username – is the account you wish to create or use.

IP – is the physical IP address of the computer you wish to grant remote access to. [note: if you enter ‘%’ instead of an IP address, that user will be able to remote into MySQL from any computer]

Password – is the password you wish to create if it’s a new user or the existing password of an existing account.

Once the command is sent and completed you must run this command afterward:

FLUSH PRIVILEGES;

if the post was helpful. please take the time to +1 it, comment, or rate it. thanks!