Linux Today: Linux News On Internet Time.

Setting, Changing And Resetting MySQL Root Passwords

Jan 21, 2009, 21:32 (0 Talkback[s])

[ Thanks to Falko Timme for this link. ]

"Method 1 - Set up root password for the first time

"If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To set up a root password for the first time, use the mysqladmin command at the shell prompt as follows:

"$ mysqladmin -u root password newpass

"If you want to change (or update) a root password, then you need to use the following command:

"$ mysqladmin -u root -p oldpassword newpass""

Complete Story

Related Stories: