Hi everyone,
I'm having some problems getting logged in to mysql to create a new
database.
I have to admit, my overall skill level with mysql is 'Entry level noob'.
I just haven't ever had much need to mess with it in general, so if you want
to laugh, feel free. I'll understand ;)
At any rate,
You should have typed ... set password = password('newpass')
You've set root's password to the encypted value of some other string.
You ought to be able to get around this by starting mysql (the server
process, not the client) using the --skip-grant-tables option and resetting
the password.
On
Method 1(install mysql):
/usr/local/mysql/bin/:
./mysqladmin -u root password 'new_password'
Method 2
mysqlUPDATE user SET password=PASSWORD('new_password') WHERE user='root';
mysqlFLUSH PRIVILEGES;
Method 3:
mysqlSET PASSWORD FOR root=PASSWORD('new_password');
On Mon, Feb 23, 2009 at 11:38 AM,