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:
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Foreword (July, 2015)
Since I first wrote this article, years ago, a great many more people have begun using the internet. They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Part of the Global Positioning System
A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and 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…