My Own Percept

Today I got the error below :

1

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

after typing :

1

mysql -u root

I don’t know why ? but I know how to solve it.
First of all let’s disable password authentication :
Stop your MySQL daemon:

1

/etc/init.d/mysql stop

or

1

/etc/init.d/mysqld stop

1

mysqld_safe --skip-grant-tables &

Secondly run :

1

mysql -u root

Finally, In your MySQL command line prompt issue the following command:

1
2
3
4

USE mysql;
UPDATE user SET password=PASSWORD("my_password") WHERE user="root";
FLUSH PRIVILEGES;
EXIT

Password is now reset to my_password. So just restart your MySQL server using :

1

/etc/init.d/mysql restart

or

1

/etc/init.d/mysqld restart

and use your new password to authenticate :

1

mysql -u root -p

All that remains is to enter your password.

Marouan OMEZZINE Tips & Tricks, how-to error, mysql

To have more fun with GTalk (Google Talk) you can add some text formatting :

• to make it bold, simply use * * (asterisk) between the text that intended to be bold in font style : i.e. *marouan* is rendred as marouan.
• to make it italic, simply use _ _ (underscore) between the text that intended to be italic in font style: i.e. _marouan_ is rendred as marouan.
• to make it strikethrough, simply use – - (dash) between the text that intended to be strikethrough in font style: i.e. -marouan- is rendred as marouan.

Marouan OMEZZINE Funny, Tips & Tricks, snippet fun, google talk, gtalk