mysql error 1042 can't get hostname for your address

mysql error 1042 can't get hostname for your address

Hi,

I am not able to connect to MySQL database. Its giving following error:

mysql error 1042 can't get hostname for your address

How to solve this error?

Thanks

View Answers

April 13, 2011 at 5:50 PM

Hi,

Find my.ini file of your MySQL Server and then add the following line to it:

skip-name-resolve

Complete code would be:

[mysqld]
port=3306
skip-name-resolve

This should solve the problem.

Thanks

Ads









Related Tutorials/Questions & Answers:
mysql error 1042 can't get hostname for your address
mysql error 1042 can't get hostname for your address  Hi, I am not able to connect to MySQL database. Its giving following error: mysql error 1042 can't get hostname for your address How to solve this error? Thanks  
Get the error messages displayed
Get the error messages displayed  How to get the error messages displayed
Advertisements
Get IP Address in Java
Get IP Address in Java In this example we will describe How to get ip address in java. An IP address is a numeric unique recognition number which...(). getHostAddress(). InetAddress():-The InetAddress is class represents an IP address
get from address using javamail api?
get from address using javamail api?  i want to get from address of particular mail using the javamail api? actually i had done it in one .jsp file... early as possible. thanks for your help
Error with LogIn with mysql database
Error with LogIn with mysql database  Hi, I have followed steps from your tutorial titled SpringMVClogin with database. I am not using Jetty, as I have Tomcat as my server using Eclipse IDE. When I run the program I get a Http
How to get factorial in mysql
How to get factorial in mysql  Hi, In order to improve the speed of my queries, one in particular tries to find matches between multiple tables, I... alot for a function in mysql to find factorial numbers of a number and couldn't
MySQL 5.1 upgrade to 5.5 error
MySQL 5.1 upgrade to 5.5 error  MySQL 5.1 upgrade to 5.5 error
MySQL 5.1 upgrade to 5.5 error
MySQL 5.1 upgrade to 5.5 error  MySQL 5.1 upgrade to 5.5 error
Get IP Address Example
Get IP Address Example       This example shows you ip address of your... : NetworkInterface.getNetworkInterfaces() : Network Interface class is used for get name, and a list of IP
ModuleNotFoundError: No module named 'aws-hostname'
;aws-hostname' error? Thanks   Hi, In your python...-hostname' error will be solved. Thanks...ModuleNotFoundError: No module named 'aws-hostname'  Hi, My Python
ModuleNotFoundError: No module named 'aws-hostname'
;aws-hostname' error? Thanks   Hi, In your python...-hostname' error will be solved. Thanks...ModuleNotFoundError: No module named 'aws-hostname'  Hi, My Python
ModuleNotFoundError: No module named 'aws-hostname'
;aws-hostname' error? Thanks   Hi, In your python...-hostname' error will be solved. Thanks...ModuleNotFoundError: No module named 'aws-hostname'  Hi, My Python
ModuleNotFoundError: No module named 'hostname-resolver'
named 'hostname-resolver' error? Thanks   Hi, In your...: No module named 'hostname-resolver' error will be solved. Thanks...ModuleNotFoundError: No module named 'hostname-resolver'  Hi, My
How to get client's address in a servlet
How to get client's address in a servlet       This is detailed java code to get client's address in a servlet. In this example we have used method getremoteAddr
how to get an lan system ip and mac address in java code
how to get an lan system ip and mac address in java code  strong text
get and display blob from mysql on jsf
get and display blob from mysql on jsf  i want to get blob from mysql, and display on jsf page. your examples with jsp. i dont find an example with jsf. plese help me about this. thanks..   Have a look at the following
Mysql Date Get Year
Mysql Date Get Year       Mysql Date Get Year is the way of retrieving the current year. Understand with Example The Tutorial illustrate an example from 'Mysql Date Get
Get your friends' phone numbers
Get your friends' phone numbers  How to create on update trigger
sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 ..
sql query to get name,age,phone,address from tables t1,t2,t3,t4,t5 ..  ... , address FROM t1 order by name"; this is for 2 tables : query ="SELECT t.name... by name"; i want for 12 tables : i want to fetch name age pwd phone address from 12
error call to undefined function mysql_connect
error call to undefined function mysql_connect  what is error call to undefined function mysql_connect
Library corruption error during apt-get update
Library corruption error during apt-get update  Hi, I am installing Jdk on Ubuntu 16.04. When i run the command: sudo apt-get update it throws following error: `appstreamcli': double free or corruption (fasttop
Library corruption error during apt-get update
Library corruption error during apt-get update  Hi, I am installing Jdk on Ubuntu 16.04. When i run the command: sudo apt-get update it throws following error: `appstreamcli': double free or corruption (fasttop
ModuleNotFoundError: No module named 'backports.ssl_match_hostname'
the ModuleNotFoundError: No module named 'backports.ssl_match_hostname' error... named 'backports.ssl_match_hostname' error will be solved. Thanks...ModuleNotFoundError: No module named 'backports.ssl_match_hostname'  
ModuleNotFoundError: No module named 'ip-addr-as-hostname'
: No module named 'ip-addr-as-hostname' error? Thanks   Hi..., ModuleNotFoundError: No module named 'ip-addr-as-hostname' error...ModuleNotFoundError: No module named 'ip-addr-as-hostname'  Hi, My
ModuleNotFoundError: No module named 'matrix-saml-strip-hostname'
the ModuleNotFoundError: No module named 'matrix-saml-strip-hostname' error? Thanks...;matrix-saml-strip-hostname' error will be solved. Thanks...ModuleNotFoundError: No module named 'matrix-saml-strip-hostname'  Hi
Java Get IP Address
Java Get IP Address       This section illustrates you how to obtain the IP Address... of "How to get IP Address in Java?": Here is the code of Java Get
Is it harder to get a job in your 40s?
Is it harder to get a job in your 40s?  Hi, I am beginner in Data...: Is it harder to get a job in your 40s? Try to provide me good examples or tutorials links so that I can learn the topic "Is it harder to get a job
How to get a list of MySQL user accounts?
How to get a list of MySQL user accounts?  Hi, I have MySQL database... of all the users. How to get a list of MySQL user accounts? Thanks   Hi, In MySQL users information is stored in user table of mysql datababse
How to get a list of MySQL user accounts?
How to get a list of MySQL user accounts?  Hi, I have MySQL database... of all the users. How to get a list of MySQL user accounts? Thanks   Hi, In MySQL users information is stored in user table of mysql datababse
get info from mysql using jsp and servlet
get info from mysql using jsp and servlet  HELLO! I wanna create a jsp page which able to let me get its name, phone and other info by asking the user to key in their email address from mysql database by using servlet and jsp too
Library corruption error during apt-get update
Library corruption error during apt-get update  Hi, I am running: sudo apt-get update but it is throwing error Library corruption error during apt-get update. Full error list: [email protected]:~$ sudo apt-get update

Ads