[MySQL] Modifying user passwords

[Ankush Grover]

On 4/26/06, Jeff Vian <jvian10 at charter.net> wrote:
>
> On Wed, 2006-04-26 at 01:28 +0200, Ali Helmy wrote:
> > Hey mates,
> >
> > I have a clean installation of MySQL 5, with a user root and no
> > password... and for some reason, MySQL-Administrator fails to modify
> > user passwords...
> >
> > So can someone tell me how to set a new password for the user root,
> > and how to create new users for MySQL through the command line?
> > Thanks
> >



mysqladmin -u root password "yourpassword" or

on mysql command prompt

mysql >    set password for root at localhost=password('yourpassword");


for creating new users

http://dev.mysql.com/doc/refman/5.0/en/create-user.html
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

Regards

Ankush Grover
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20060426/4676a475/attachment-0001.htm>