MySQL Forums
Forum List  »  General

Re: Creating User
Posted by: Rik Chong
Date: April 03, 2005 02:22AM

You can use mysql client program to update it:

mysql>USE mysql;
Database changed

mysql>UPDATE User SET User = "pavan", password = PASSWORD("your password here") WHERE User = "root";
Query OK, 1 rows affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Good luck,
-- Rik

Options: ReplyQuote


Subject
Written By
Posted
April 03, 2005 12:09AM
Re: Creating User
April 03, 2005 02:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.