How to reset password root mysql
May-25-2015 By admin
Tag : reset password root mysql
if you forgot password root mysql please following below:
***********************************
#killall mysqld
#/usr/local/libexec/mysqld –Sg –user=root &
#mysql
mysql>use mysql
mysql>UPDATE user SET password=password(“newpassword”) WHERE user=”root”;
#service mysqld restart
or
#shutdown -r now
Posted in: Linux Server install and setup.