Cannot Connect To An Instance Of Mysql 4.1

[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