Page 1 of 1

Mysql code help needed.

Posted: Tue Mar 28, 2006 8:12 pm
by Cheeseboy
Hi, i used this code i got from a tutorial:

Code: Select all

mysql> update user set User='NewRootName',
    -> Password=password('NewPassword') where User='root';
Im starting to get scared because it wont let me login.
This is what i enter:

Code: Select all

mysql> update user set User='root',
    -> Password=password('linux4ever') where User='root';
Could somebody please tell me what my username and password is?
Please help

Posted: Tue Mar 28, 2006 11:47 pm
by jrd
if you wanted to change your root password, you should have done it like this :

Code: Select all

mysql> SET PASSWORD FOR root@localhost=PASSWORD('linux4ever');

Try running this command to reset your root password :

http://news.postnuke.com/Article1273.html

might be of help to you.