Mysql code help needed.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Cheeseboy
Forum Commoner
Posts: 67
Joined: Thu Mar 23, 2006 2:43 pm

Mysql code help needed.

Post 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
jrd
Forum Commoner
Posts: 53
Joined: Tue Mar 14, 2006 1:30 am

Post 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.
Post Reply