#2 Unable to connect

[Anonymous]

I have setup MySQL, and am able to connect to it using
the mysql command line tool, or via JDBC applications for
example.

On firing up CocoaMySQL, and trying to connect (using
localhost or 127.0.0.1 or full domain name as hostname),
I just get a Connection failed dialog.

(This is MySQL 4.1 alpha).

[Lorenz Textor]

Logged In: YES
user_id=557461

The current version can connect to MySQL 4.1 only when no
password is set!

[Nobody/Anonymous]

Logged In: NO

Hi...

I have the same problem with my host who is running MySQL
4.1 alpha too. They wrote me that I can't connect to it
because of the newer version of MySQL?! Hope that is not
true. :(

[Lorenz Textor]

Logged In: YES
user_id=557461

Unfortunately the current version really cannot connect to MySQL
4.1 if a password is set, because version 4.1 uses a new format
for the encrypted passwords. You can still connect to it when no
password is set, but that's a bad idea when remote access is used.
The next version will use an updated framework and the new
MySQL sources to support also version 4.1 of the server.

Sorry for that!

[Nobody/Anonymous]

Logged In: NO

I just downloaded and am having connection problems with
MySQL 3.23.56, is this also the issue with that version?

[Lorenz Textor]

Logged In: YES
user_id=557461

If you cannot connect to version 3.xx, it's a different problem. The
password problem only exists with version 4.1.
Have you tried connecting to 127.0.0.1 instead of localhost? Can
you connect to MySQL using the terminal, but in CocoaMySQL the
same login/pass doesn't work?

[Nobody/Anonymous]

Logged In: NO

this user has posted a fix...

http://www.theonline.org/cocoamysql/