Quickzi: How To Change MySQL Root Password

Here is how to change the mysql root password from the Linux command line. Replace “root” with any user name to change any mysql user password.

Change MySQL Password

# /etc/init.d/mysql stop
# mysqld --skip-grant-tables
# mysqladmin -u root password 'newpasswd'
# /etc/init.d/mysql start

Cheers!

Popularity: 6% [?]

Tagged with: HowTo • Linux • mysql • quickzi • tips

Filed under: HowTo • Linux

Like this post? Subscribe to my RSS feed and get loads more!