Prev: Update from 10.2 to 10.3
Next: Printing in Japanese
From: Miguel Lopes on 21 Jan 2008 07:41
Hello I was installing suse 10.2 and i put in a password for mysql but for
some reason it does accept it.

How can I reset that password.

Thanks


From: Michael Soibelman on 22 Jan 2008 12:45
Miguel Lopes wrote:

> Hello I was installing suse 10.2 and i put in a password for mysql but for
> some reason it does accept it.
>
> How can I reset that password.
>
> Thanks


How to Reset a MySQL Password in 5 Easy Steps
Stop the mysqld daemon process.
Start the mysqld daemon process with the --skip-grant-tables option.
Start the mysql client with the -u root option.
Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE
User='root';
Execute the FLUSH PRIVILEGES; command.
These steps reset the password for the "root" account to "password". To
change the password for a different account, or to set a different
password, just edit the variables in single-quotes in step 4.
If you know your existing MySQL root password, steps 1-3 are not necessary.

 | 
Pages: 1
Prev: Update from 10.2 to 10.3
Next: Printing in Japanese