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
Richard ComitoDirector of ITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan McFaddenSystems EngineerCommented:
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
0
Richard ComitoDirector of ITAuthor Commented:
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
0
Dan McFaddenSystems EngineerCommented:
SSMS is only for MSSQL. So unfortunately you cannot manage MySQL with it.  I would recommend Heidi SQL as a good GUI for MySQL administration.

Link:  http://www.heidisql.com/

As someone who has to deal SQL Servers on a daily basis, I found HeidiSQL the easiest to use when compared to SSMS.

And as a side bonus, HeidiSQL can connect to & manage MSSQL Servers.  Not with 100% functionality but pretty close.

Dan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Richard ComitoDirector of ITAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.