Root is tryng to resolve to a Chinese IP address
Posted by:
Osa Walls
Date: November 17, 2017 10:14AM
I have had to add PHP and MySQL to two of my web servers to accommodate a client who I am developing and hosting a web site that requires PHP and SQL. PHP is pretty straight forward, but MySQL is more like a science project. Both of them are working except that I have an error that it is trying to resolve localhost to a Chinese IP address. When I log into the SQL database, I connect to the correct data directory, but is seems to be trying to send the table and schema to China
Both servers were setup using the MySQL 5.7 installer and both have the same problem. Using root and password takes me to the correct directory as does localhost with a secondary user password. If it is any help, here is the last two lines of the log file.
"[Warning] IP address 222.186.129.120 could not be resoled: No such host is known"
"[Note] Access denied for user 'root'@'222.186.129.120' (using password: YES)"
I think root should always be 127.0.0.1 in this particular application. All data input and output are within the confined of the server. No public connections are required.
I am sure this would be easy to fix if I had more experience with MySQL in this application......Any recommendations?
Subject
Written By
Posted
Root is tryng to resolve to a Chinese IP address
November 17, 2017 10:14AM
November 17, 2017 10:45AM
November 17, 2017 11:39AM
November 17, 2017 01:07PM
November 17, 2017 03:23PM
November 28, 2017 11:41PM
November 29, 2017 09:37AM
December 08, 2017 07:00PM
December 08, 2017 09:24PM
December 13, 2017 02:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.