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