[jkocsis]

I have a similar problem to John's. I used to be able to connect with no problems using the SSH tunnel.

My settings are like this:

Server Tab:

MySQL Host Address: localhost

User Name: My DB user name

Password: My DB password

Port: 3306

Default Charset: default

Databases: blank

Tunnel Tab:

Use SSH Tunneling: checked

Username: My SSH username

Password: My SSH password

SSH Host: the name of my remote host

SSH Port: 22

Local Port: 3310

These settings would always work with no problems in the past. However, we recently made a change to the my.cnf config file. In the past we didn't use the “bind-address” parameter. We now added that and set the bound address to the IP address of the machine that is running the mySQL instance.

Now when I try and connect using SQLyog I get the “Error No. 2013 Lost connection to MySQL server during query” message. If I change the “MySQL Host Address” field in the Server tab from localhost to the IP address we are binding to in the my.cnf file then I get the message “Error No. 1045 Access denied for user…” error. That would make sense since the user in MySQL is only allowed access from localhost.

Is there a way to use the “bind-address” parameter in my.cnf and still use SQLyog? I'm using version 5.19.

[jkocsis]

Just checking back to see if you were able to find anything about this freezing problem. Thanks.

[jkocsis]

I just tried the Data Synch in Powertools and that successfully worked. I guess that would be a workaround, but it would still be nice if I purchase this product to be able to use the other options. I'll wait to hear if you find anything. Thanks for your help.

[jkocsis]

For my new problem please refer to this post instead. Thanks.

[jkocsis]

I think I may have fixed these problems. I was using the server ip as the host for the unsuccessful user instead of localhost. The successful user was recently changed to have localhost in the user table but a “flush privileges;” wasn't done on it. I did that and now both work as expected.

I have a new problem though. When I try to copy a table to a different DB on the same host the SQLyog app freezes. I've tried several tables and it freezes on all of them. These tables have very few rows (under 20). I also tried just copying the table structure, but even that freezes the app. Any ideas on this one?

[jkocsis]

The mySql app is hosted internally and not through an ISP. We are using the mysql.user table and as far as I know nothing strange is being done with it. Is there anything I can check to make sure no one has done anything odd with it? I would love to be able to edit users from this app.

I can confirm the password being used is correct. I've tried multiple times and it doesn't work. When I try connecting to mySql inside the Putty shell directly using the same username and password it works.

Here are the results from the “SHOW GRANTS” operation. And this may perhaps shed some light. Or at least I hope. I really want to use this app.

For the user that can successfully connect I get this:

ERROR 1141: There is no such grant defined for user 'SuccessfulUser' on host 'localhost'

For the user that cannot connect I get this:

GRANT ALL PRIVILEGES ON *.* TO 'UnsuccessfulUser'@'localhost' IDENTIFIED BY PASSWORD 'xxx' WITH GRANT OPTION

I thought it was odd that the user which can connect successfully comes up with an error saying there are no grants even though in the user table everything is set to Y and that the user which cannot connect is coming up with privileges.

The version of SQLyog I'm running is 5.17. I'm using the trial version right now. I wanted to check it out to make sure it fulfills all my needs before purchasing it.

Hope this helps.

[Author]

Posts