-   Linux - Newbie (
-   -   MySQL connection problem (

wendle 09-26-2008 06:44 PM

MySQL connection problem
I am trying to connect and administrate a mysql database through various programs (mySQL administrator, emma, mySQL navigator) but i keep having this message
"Could not connect to host "host name".
MySQL Error Nr. 1045
Access denied for user 'username@'' (using password: YES)

Click the 'Ping' button to see if there is a networking problem.

Now if I ping, the server is responding. By the way the port is 3306 but I' ve tried some other ports without any luck.
Could anybody help in any way. Thanks

elprawn 09-26-2008 07:04 PM

Have you set up port forwarding?

wendle 09-26-2008 07:09 PM

Port forwarding in the wireless router you mean?

elprawn 09-27-2008 03:55 AM

Yeah, if you're trying to access outside the router then you have to forward port 3306.

wendle 09-27-2008 05:44 AM

Ok. I get it. BUT my stupid router hasn't got a port forwarding function. It only has a "FIREWALL RULES" with some predefined values (nothing about port 3306). The closest is the SQL-NET(TCP:1521) and another witch says ANY/ALL(TCP/UDP:1-65535). I checked the "allow" button next to them but still no luck!!!

elprawn 09-27-2008 06:30 AM

Which router do you have?

wendle 09-27-2008 10:45 AM

Level1 Wbr-3460a

elprawn 09-27-2008 11:48 AM

Is there no way of setting custom rules or do you have to choose from the list?

wendle 09-28-2008 10:55 AM

It has only some predefined values (nothing about port 3306). the closest that i can find is: ANY/ALL(TCP/UDP:1-65535).this is already turned on but still no luck

elprawn 09-28-2008 11:08 AM

Is that a rule for port blocking/allowing or port forwarding? i.e. does it ask you for a local address? Have you tried plugging your MYSQL server straight into the Internet rather than going through your router? (this way you could eliminate other possibilities).

jgallo 09-28-2008 08:45 PM

Look for a setting called NAT maybe.

You might want to look for another router if you cannot find these settings. Or check into if a third party firmware like OpenWRT or DD-WRT support your router.

osamaensyviswinkel 09-30-2008 02:36 AM

1. can you telnet to your box on 3306, firstly on localhost?

you should see something like this:

[09:59][root@server]/home # telnet localhost 3306
Connected to localhost.
Escape character is '^]'.

2. what kind of a router/router version have you got? Normally if you've got those default values, there's an option to setup custom firewall/port rules where you select the port number, you name it whatever you like etc.

All times are GMT -5. The time now is 06:29 PM.