Sqlyog And Old Password

[soasian]

Hi all. I run these two queries while in root because I was having problem connecting to MySql with the latest MySql connector for .Net.

SET SESSION old_passwords=FALSE;

SET PASSWORD = PASSWORD('[your password]');

Now, I can't connect to mysql using Sqlyog. I'm getting access denied. Is there a way to fix it? The root's password length is 41 from 16. I have access to the server.

Thanks.

[peterlaursen]

We have replied in you ticket already. What is the idea in contacting us twice?

We replied:

You do not provide enough information.

* What is the SQLyog version you are using?

* What is the exact MySQL version. “5” can be anything from 5.0 to 5.6 (and there is * almost 10 years between them). Please execute “SELECT VERSION();”

* How do you connect from SQLyog? direct connection? SSH tunnel? HTTP/tunnel?

* Do you have a setting in MySQL configuration like 'OLD_PASSWORDS'?

The 16-character hash was used as default by MySQL up to and including version 4.0. From 4.1 the 41-character has is default. There is only one reason to use the 16-character hash ('OLD-PASSWORDS') with recent servers if you need it for compatibility with old clients (such as PHP 4.3 and earlier). The 16-character hash is not very secure.

SQLyog should be able to handle both, however. What is the exact error you get when trying to connect? 'Access denied' or 'Connection denied'?

[peterlaursen]

1) Are you sure that you did not change the password? Please try (if you did not) to create a new connection in SQLyog user manager.

2) Also are you sure that connection from remote hosts are allowed for root user?

[Author]

Posts