MySQL connection problem

wendle · 09-26-2008, 06:44 PM

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@'vfppp079167045089.dsl.hol.gr' (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
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
4
5.0.37@/kP0:tYB,}o5X;]CwPg8

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.