Setting, Changing And Resetting MySQL Root Passwords

[ 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:

• Intro to MySQL Proxy(Jan 15, 2009)
• Installing Nginx With PHP5 And MySQL Support On Ubuntu 8.10(Jan 15, 2009)
• MySQL developers denied Aussie visas(Jan 14, 2009)
• Sun expanding MySQL Drizzle staffing - going cloud?(Jan 13, 2009)
• Installing Nginx With PHP5 And MySQL Support On Fedora 10(Dec 28, 2008)
• MySQL, YourSQL, OurSQL(Dec 18, 2008)
• Administering MySQL Databases on the Web Using PHP(Dec 09, 2008)