mysql error 1042 can't get hostname for your address

Hi,

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

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

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 '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

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

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

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