distal-attribute
distal-attribute
distal-attribute
distal-attribute

Can't Connect error 1042

User, date Message
Written by Ragoczny
3 years ago
Category: Creating a connection
2 posts since Thu, 23 Feb 12
Hello,

I'm trying to access my database remotely from my computer but keep getting error 1042 i tried to configure my router to let the port 3306 through but no luck as well tried to add exception to firewall but still no luck there.

please help

thx
Written by kalvaro
3 years ago
595 posts since Thu, 29 Nov 07
Do you mean Can't get hostname for your address?

http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html#error_er_bad_host_error

(Please don't strip error messages, the the information provided is always relevant.)

That's a server error so you are actually communicating with the MySQL server. You normally need to configure your router for incomming connections.

I'm not familiar with the error but it suggests that the server is configued to obtain the DNS name of clients but your router's public IP address does not have a valid matching hostname, e.g.:

C:\>nslookup xx.xx.xx.xx



... does not return a name. If you control the MySQL server, you can change its settings as explained at http://stackoverflow.com/questions/5118151/mysql-error-cant-get-hostname-from-your-ip-address-whats-the-problem
Written by Ragoczny
3 years ago
2 posts since Thu, 23 Feb 12
Thank you so much the links really helped a lot

i was stuck for the longest time thank you again

:)
 

Please login to leave a reply, or register at first.