Login Problems

[jkocsis]

I'm connecting to the server that mySql is running on using SSH tunneling. The user is set up as a localhost in the Host field in the mysql.user table. I have no problems connecting as this user. There is another user set up that also has localhost in the Host field in the mysql.user table. All the rights are identical in the user table as the first user. However, I receive a 1045 error telling me access is denied for that user. If everything is identical in the user table and I'm using SSH which sees me as localhost, then why wouldn't the second user be able to connect? I can connect just fine in Putty, which I know isn't the same when using SQLyog. But since I'm using SSH tunneling in SQLyog I would think it is identical. Plus I know I can connect with at least one of the users and both have the same rights.

Also, the first user that can successfully connect is having access rights problems when I try modifying user permissions. Whenever I make a change in Tools|User Manager and try to apply the change it gives me the same 1045 error as I have above. However, when I cancel out of the operation and query the user table the changes have actually taken place. Why am I getting the 1045 error then?

I also get the 1045 error when I try to copy a table to another DB in the same host. The problem here unlike above is that the action really doesn't happen (i.e. no table is copied). At least above the user permissions are mysteriously changed. And again this is obviously using the user that can successfully connect which has full rights.

There may be other things I can't do as well, but these are the things I've tried with the successful user. I can run SQL commands (select, update, etc.) without problems. The mySql version is 3.23.49.

I really want to use this product. I think it offers everything I need in a mySql interface, but I won't be able to if I can't connect and modify permissions properly. Any help is greatly appreciated.

[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