How to change MySQL root password

I read a great blog today about SQL tricks for Wordpress and thought I would create an additional SQL blog about an issue a co-worker and I ran into a while ago…”How to change MySQL root password”.  This blog assumes that you have shell access to the server that is running your MySQL database.  If you only have C-panel access then you will just have to contact your provider.  Also, it’s important to understand that the root user for the operating system is not the same as the root user for MySQL.  They are completely separate accounts.

First you must SSH/Telnet to the host that is running MySQL and then type the following command:

$ mysqladmin -u root password NEWPASSWORD

Filed Under: Technical Instructions