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!
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!