asked on

How to add IPs to mysql on a 2012 Windows Server

I needed to add Wordpress to a windows server 2012 with mysql. everything is installed correctly and the system is working. However, I am not able to telnet to mysql from my workstation.

I keep getting this error: F*Host 'real ip not shown here' is not allowed to connect to this MySQL server

I logged into the mysql server and by using mysql.exe I typed in:

GRANT ALL ON *.* to root@ 'real ip not shown here' IDENTIFIED BY 'real password that is not shown here'

FLUSH PRIVILEGES

I assume that I did this correctly because after each command I to nothing back. (Linux/Unix code for you did it right. I think?)

But when I try to telnet into the server from the IP that I used in the first command. I get the same error.

Am I missing something?

Thanks

Dan McFadden

1. Can you connect to the MySQL instance locally from the server desktop?
2. Is there a physical firewall between your workstation and the server?
3. Is the Windows Firewall blocking the default MySQL port? (3306/tcp)
4. Have you changed the port the MySQL functions on?
4a. If so, have you allowed that port thru the Windows Firewall?
5. What tool(s) are you using to manage the MySQL instance? (MySQLadmin, HeideSQL, etc.)

Dan

Richard Comito

ASKER

Hi Dan,

Sorry for the delay. Was on Vacation then a conference. Here are my responses to your questions.

1. Can you connect to the MySQL instance locally from the server desktop? -- Yes
2. Is there a physical firewall between your workstation and the server? -- Yes but I tested the port with telnet.
3. Is the Windows Firewall blocking the default MySQL port? (3306/tcp) -- I confirmed that the port is open on the windows firewall.
4. Have you changed the port the MySQL functions on? -- no
4a. If so, have you allowed that port thru the Windows Firewall?
5. What tool(s) are you using to manage the MySQL instance? (MySQLadmin, HeideSQL, etc.) -- I am trying to set up an ODBC connection using Oracle's ODBC connector for mySQL

our business is mostly Microsoft and I only use ssms. However I had to install WordPress on a windows 12 box and I am trying to figure out how I can access the DB using ssms.

Thanks for your help,

Rich

ASKER CERTIFIED SOLUTION

Dan McFadden

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Richard Comito

ASKER

Thanks Dan, A little bit of a learning curve on the GUI for a ssms guy. But it looks like it will do the trick. Best, Rich