Newbie/Evaluation – Cannot access MySql server

[kellypw]

I'm sure these question have been answered previously, so my apologies in advance.

I've recently inherited several MySQL databases all running on Linux machines (one detailed config below). My desktop env is Windows XP. I'm having a problem connecting SQLyog Enterprise edition (evaluation) to a MySQL instance. Details:

I'm able to successfully ssh from my XP machine via SecureCRT to the linux machine, and log into the MYSQL database. The SSH port is 22.

MYSQL version:

Server version 3.23.58

Protocol version 10

Connection Localhost via UNIX socket

UNIX socket /tmp/mysql.sock

Uptime: 18 min 33 sec

Linux:

RedHat (not sure – 8? free version)

Following the very explicit help doc, I created a connection using ssh tunneling (NOTE – mysql host and SSH host ip are the same). When I test the connection, I get Error 1130: Host (the IP address that is both the mysql and the ssh ip) is not allowed to connect to this MySQL Server.

I also checked the variables in the MySQL instance and the port is listed as 0? I also commented out the mysqld paramater skip-networking and added skip-resolve-name.

Any help would be most appreciated. If I can use the tool, I'll buy it!

[CalEvans]

Sounds like when you are sshing in and connecting you are connecting as whomever@localhost. When you are creating a tunnle, you are connecting as whomever@ip. You need to grant permissions to whomever@%. See if that doesnt' solve the problem.

=C=

[kellypw]

unfortnately, no, that didn't work eiterh. previously, I was not specifying a database (the help doc indicated that if i did not, it would list all databases), but after issuing grant all on a particular database and then specifying that database, it still gave the same error.

any other ideas?

[Ritesh]

Can you post screenshots of your connection window (both server and tunnel details)?

[Author]

Posts