Cannot Connect To An Instance Of Mysql 4.1

[tfsmag]

I have a client who has a hosted mysql 4.1 database the other developer on a mac can connect from cocoa mysql using the login information. I cannot do the same in SQLYog. It gives me an access denied error. Is this because of the change from 4 to 5 with the password handling? I really really need to get into this database so that I can get paid. Someone please help me! I remember using sql yog a couple of years ago to get into mysql 4 databases, do I need a previous version? Thanks

[peterlaursen]

1) the different passwords handling with different MySQL version only affect SQLyog when HTTP-tunnelling. The PHP binaries and the Server binaries must match. This is NOT AT ALL a SQLyog issue!

The solution is to configure the specific user to use the old passwords handling.

http://webyog.com/faq/content/23/18/en/err…on-denied-.html

2) Please read

http://webyog.com/faq/content/23/18/en/err…on-denied-.html

.. probably only connection from 'localhost' is allowed for this user and you are trying to connect from a remote host?

[tfsmag]

peterlaursen wrote on Oct 27 2007, 03:36 AM:

1) the different passwords handling with different MySQL version only affect SQLyog when HTTP-tunnelling. The PHP binaries and the Server binaries must match. This is NOT AT ALL a SQLyog issue!

The solution is to configure the specific user to use the old passwords handling.

http://webyog.com/faq/content/23/18/en/err…on-denied-.html

2) Please read

http://webyog.com/faq/content/23/18/en/err…on-denied-.html

.. probably only connection from 'localhost' is allowed for this user and you are trying to connect from a remote host?

Hi peter, thanks for the response…

If it's the localhost only issue, why was my colleague able to login from his mac using cocoa mysql? This mysql instance is on a webhost so I don't think I have access to configure the user's password to even try that. I suppose I could put in a trouble ticket and see where that gets me. thanks.

[peterlaursen]

I thougt the MySQL server was running on that MAC.

Maybe there was a user configured for specific ip's?.

If it is a shared/hosted server at an ISP, then it is a chance that you will have to allow access from specific ip's from a webbased control panel.

Unless of course user or password was typed wrong (lettercase?) or some similar trivial mistake!

[Author]

Posts