Re: [MySQL] Modifying user passwords

["Ankush Grover" <ankush174@xxxxxxxxx>]

On 4/26/06, Jeff Vian <jvian10@xxxxxxxxxxx> 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@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