Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


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: