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









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  
can't connect to MySQL Server(10060) - JDBC
can't connect to MySQL Server(10060)  Hii Sir, I am working with a jsp project with MySQL as server. Now i want to host my application. I am... MySQL front end. Can we connect to the MySQL server using the I.P address
Advertisements
PHP Get Browser IP Address
PHP Get Browser IP Address PHP provides us  $_SERVER['REMOTE_ADDR'] function is used to display the Browser IP address PHP Get IP Address Code:ADS_TO_REPLACE_1 <?php echo "My Browser IP is :". $_SERVER['REMOTE
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. ADS
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
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
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
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 '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
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
Get the error messages displayed
Get the error messages displayed  How to get the error messages displayed
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
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
Java Get IP Address
Java Get IP Address   ... tutorial of "How to get IP Address in Java?": Here is the code of Java Get IP Address ExampleADS_TO_REPLACE_2
Find Your Host Name/IP Address
Find Your Host Name/IP Address   ... the getLocalHost() method to print the Host name as well as the IP Address of the local... ("Can't detect IP Address : " + e
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
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
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
why this can't
why this can't  import java.util.*; class Dash{ public static void main(String args[]){ int x0=100; int[] x1=new int[3]; int[][] x2=new int[3][3]; int[][][] x3=new int[3][3][3
Error in MySQL Procedure Using JAVA Code
Error in MySQL Procedure Using JAVA Code  The following Java code (using Connector/J to create a stored procedure on MySQL 5.0) does not execute successfully. Identify the cause and available solutions. statement.execute
backup your MySQL data using mysqldump:cPanel MYSQL 5.1 to 5.5
backup your MySQL data using mysqldump:cPanel MYSQL 5.1 to 5.5  backup your MySQL data using mysqldump:cPanel MYSQL 5.1 to 5.5
getting error in your login form code
getting error in your login form code  i tried your code for login form but i am getting an error.the error is undefined index userid...   hi friend, your form's input must have following : <input type
Get Noticed with Your Resume
Get Noticed with Your Resume     ... the importance of your resume- they tell you that your resume can make or break your chances to get to the interview. No matter how often repeated, this point could never
Mysql Date Get Year
Mysql Date Get Year       Mysql Date Get Year is the way of retrieving the current year... 'Mysql Date Get Year'. To understand and grasp this example, we use
Get your friends' phone numbers
Get your friends' phone numbers  How to create on update trigger
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
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
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: deepak@deepak-VirtualBox:~$ sudo apt-get update
Get an Editor to polish your pages
Get an Editor to polish your pages   ... will improve the credibility of your site as bad language makes the users lose confidence in the material that they will find on your site. Editors can also make
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
Starting MySQL.. ERROR! The server quit without updating PID file
Starting MySQL.. ERROR! The server quit without updating PID file  I...: Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib... and the error is gone. This error "Starting MySQL.. ERROR! The server quit without
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
Java example program to get IP address of own system
Java example program to get IP address of own system       java get own IP address An IP...=InetAddress.getLocalHost(); gets the computer system's local host with IP address. Now we can get
ModuleNotFoundError: No module named 'address'
' error? Thanks   Hi, In your python environment you have..., ModuleNotFoundError: No module named 'address' error will be solved...ModuleNotFoundError: No module named 'address'  Hi, My Python
online address book
online address book  how to create online address book using jsp and mysql
error
,address,ss; int mos,phone; double it; public void accept(String n,string ad,int ph,String s,int ms) { name=n; address=ad...() { System.out.println("Name"+name+"\naddress"+address+"\nphone no"+phone
how to get the details of username&password of mysql - JDBC
how to get the details of username&password of mysql  Hi friends, i installed mysql 5.5 on my system successfully,but the thing is i forgotten the username and password .please tell me how to get those details . Thanks
Overview of Networking through JAVA,Find Your Host Name
Find Your Host Name   ...() method and pass it in the object. In this way we find out the ip address... import java.net.*; public class Hostname{  
Java Get Host Name
Java Get Host Name       In this Example you will learn how to get host name in Java... name of a computer or an IP address using Java application language. The given
Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or
Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or  Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or â
cPanel upgrade MySQL 5.1 to 5.5
MySQL 5.5 and use can use the cPanel wizard to upgrade your MySQL server 5.1... for for proceeding. ADS_TO_REPLACE_2 Step 1: Backup your MySQL data using mysqldump..._TO_REPLACE_10 Step 3: Copy my.cnf and restart MySQL Login to your MySQL server

Ads