Login Problems

[peterlaursen]

Please answer: what is the SQLyog version that you are using?

Please let us see the returns of a

Code:

SHOW GRANTS for 'user'@'localhost'

for both users.

Quote:

I receive a 1045 error telling me access is denied for that user.

are you sure that the password is correct?

[peterlaursen]

BTW:

at ISP's it is not unusual that you will need to use their Control Panel application to edit users.

They sometimes do weird things with the mysql.user table (and sometimes just do not use it – the CP app operates its own user table!).

[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.

[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]

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

[peterlaursen]

Quote:

The mySql version is 3.23.49.

I do not know if there could be an issue here. With 3.23.58 and SSH tunnel it works fine here.

Please test the other features as well in between. I will need to ask developers WHAT SQLyog does in detail here (HISTORY does not record 'copy table')

I think the 'freeze' is simply because MySQL does not respond.

[Author]

Posts