MySQL database/username created --> Access denied

deamen

Verified User
Joined
Jul 12, 2005
Messages
5
Hi there,

When a user creates a new database, it doesn't allow the user to login with the given password.
The username and database is created, but there is something strange with the way DA is setting the password.

Wen I give hte following commands on the commandline it works.
Note the "OLD_PASSWORD" instead of the "PASSWORD".

use mysql;

UPDATE user SET password=OLD_PASSWORD('temp') WHERE user='username_temp';

FLUSH PRIVILEGES;


Can anyone help me out with this strange behaviour?

Thanks!
 
Back
Top