Solved

Trying to connect remotely to a MySQL server

Posted on 2016-10-07
10
25 Views
Last Modified: 2016-10-15
Hi,

I'm running MySQL version 5.6.22 on a Win 2012 server and am trying to create a web interface which will allow me to manage users remotely.

I've got the PHP code working locally but am now trying to connect to this server remotely and running into problems. The Port is open from this server to our LAN address but when I try to connect using telnet I get the following error:

Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server.

So I thought I would dial it back a bit and test locally on the server.

So I'm now testing locally on the server and I can connect using:

mysql -h localhost -u administrator -p

but if I try:

mysql -h xxx.xxx.xxx.xxx -u administrator -p

It prompts to enter the password as usual but then gives me:

ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)

I'm sure I have perms to connect from any host as I ran:

SELECT User,Host FROM mysql.user;

and got:

+---------------+-----------+
| User          | Host      |
+---------------+-----------+
| administrator | %         |
| root          | 127.0.0.1 |
| root          | ::1       |
| administrator | localhost |
| root          | localhost |
+---------------+-----------+

I've now come screeching to a halt in my knowledge of MySQL and could really do with some guidance please.

Thanks.
0
Comment
Question by:Letterpart
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41833542
Have you checked Windows Firewall on the 2012 server to ensure that port 3306 is open and allowing you through.
0
 
LVL 1

Author Comment

by:Letterpart
ID: 41833566
Sorry, yes.

The Windows Firewall is switched off for testing.
0
 
LVL 1

Author Comment

by:Letterpart
ID: 41833572
Just to add.

When i test it locally with

mysql -h xxx.xxx.xxx.xxx -u administrator -p

It prompts to enter the password as usual but then gives me:

ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)

So it is def getting through to MySQL.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41833661
Is the IP you are connecting to the server on the internal network address or external?
0
 
LVL 1

Author Comment

by:Letterpart
ID: 41833665
I'm testing this on the local machine to rule everything else out.
0
 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41833772
So mysql -h localhost works?
0
 
LVL 1

Accepted Solution

by:
Letterpart earned 0 total points
ID: 41833784
Yes. as per above.

Now, I've just run the following command:

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'thepassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Open in new window


And am now able to connect using:

mysql -h xxx.xxx.xxx.xxx -u administrator -p on the local machine. So that's me one step closer. Now need to test connecting from a remote machine.
0
 
LVL 57

Assisted Solution

by:Julian Hansen
Julian Hansen earned 500 total points
ID: 41833818
That should work now - sorry I thought I had already done a post regarding GRANT PRIVILEGES - but seems it did not go through.
0
 
LVL 1

Author Closing Comment

by:Letterpart
ID: 41844868
I resolved the issue myself but appreciate the time Julian put in to the question to help resolve it so would like to assign him points.
0
 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41844879
Thank you and you are welcome.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Duplicated data in GROUP_CONCAT 2 52
database connection error mysql stops 7 82
php time 12 29
How to convert PHP array into string ? 16 25
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question