Advertisements
BTNHD News

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!

Advertisements
About BjTechNews (896 Articles)
An IT guy trying to learn everything about technology and sharing it with you all. I'm a blogger and video blogger who highlights daily news in the tech industry, promoting tips and hacks for fellow techies.

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

  1. Very well explained. 🙂
    Thanks a lot. Helped me in my time of need. Keep up the good work.

  2. Thank you! I didn’t watch the video, the commands were enough for a Linux instance. In case someone get stuck as I did: besides granting access in MySQL, you shouldn’t forget to open the 3306 port or stop the firewall at all.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s