MYSql Windows 2003 - Connection Error

[Corflex]

I installed MYSql/PHP/Apache on my Windows 2003 server. I created my database, added users and granted FULL perrmissions to all my uses but when i go to connect i get:

There seems to be a problem with the MySQL server, sorry for the inconvenience.

So I start the MYSql server by the command:
mysqld --skip-grant-tables

and I can get in fine from the webside but once i get it out of this mode i can't hit it from the webside BUT i can hit it with MYSql GUI tools to setup users/db/grants/etc.

All idea why and what i need to do?

Thanks

 

[dalchri]

You might need to store your passwords using the OLD_PASSWORD function depending on your database version and client version.

The newer versions of MySQL use a longer encryption scheme to store the passwords but the older clients can't match the encryption scheme.

Try updating the grant table as follows:

UPDATE mysql.users
SET Password = OLD_PASSWORD('Password');
WHERE User ='Username'
FLUSH PRIVILEGES;

 

[Corflex]

Thanks for the info but i am a little lost -

Let's say my user name is bob & password is larry - How would your above command be entered?

I tried it but it desn't seem to work.

I am running:
php 4.3.2
mysql 4.1.7
Apache 2.0.52

Just a side note, i conect connect with user name ODBC

 

[dalchri]

Sorry, had the table name wrong. user singular, not users plural:

UPDATE mysql.user
SET Password = OLD_PASSWORD('larry');
WHERE User ='bob'
FLUSH PRIVILEGES;


You'll definitely need to do the above if you are using ODBC to connect.

 

[Corflex]

Thanks, it worked so that makes you DA MAN - Happy Holidays and Thanks for the x-mas gift -