MySQL Change root password March 7th, 2010
If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:
However, if you want to change (or update) a root password, then you need to use following command
For example, If old password is abc, and set new password to 123456, enter:
1 |
mysqladmin -u root -p'abc' password '123456' |
source here
This entry was posted on Sunday, March 7th, 2010 at 7:16 pm and is filed under databases, linux, mysql, Networking. You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.
