MySQL error: Can't get hostname from your ip address
52,572
Just add below in my.ini or my.cnf.
[mysqld]
skip-name-resolve
Linux:
Otherwise, start MySQL server with the following flag:
sudo service --skip-name-resolve
For more information: http://dev.mysql.com/doc/refman/5.0/en/host-cache.html
Related videos on Youtube
10 : 50
Failed Exporting Database | Network Error | Mysql - phpMyAdmin - Xampp
04 : 30
How to fix: Host 'IP' is not allowed to connect to this mysql server
02 : 54
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) solved
![[Solved] Error: MySql Shutdown Unexpectedly [2022 Update] MySql not starting in Xampp Server](https://i.ytimg.com/vi/ipMedkjMupw/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLD2fnp0piaMes-oNEX_ppbCrd3DZQ)
06 : 50
[Solved] Error: MySql Shutdown Unexpectedly [2022 Update] MySql not starting in Xampp Server
05 : 57
How to fix a network-related or instance-specific error connecting to SQL Server
01 : 36
How to find the hostname and IP address of your system
04 : 15
ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10061)
04 : 27
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error") - Debugged
03 : 51
mysql-ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/data/data/com.termux
01 : 19
ERROR 2003 (HY000) Cant connect to MySQL server on hostname (111) - MySQL
01 : 01
MySQL error Cant get hostname from your ip address - MySQL
Comments
-
Jean Louis over 4 years
I use my remote MySQL database during long time.
But today I suddenly have found that I cannot connect to the database. I have got an error.
"Can't get hostname from your ip address".
I haven't changed anything in MySQL settings.
What's the problem?
-
wimvds about 13 yearsAs the error states : MySQL is unable to resolve your current IP to a hostname (ie. it cannot perform a reverse lookup on your current IP). Check this bug report and also how MySQL uses DNS for some background info.
-
-
Sajal over 10 yearsi am having same problem. Can anyone explain how to resolve it. This answer is not clear to me.
