First stop the mysql daemon service
# /etc/init.d/mysqld stop
Then, run following command in terminal
# mysqld_safe --skip-grant-tables &
Now login mysql
# mysql -u root mysql
Change root password
mysql > UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit
Now start the mysql daemon service
# /etc/init.d/mysqld start
# mysql -u root -p
I hope , Now you can able to login with root user.
# /etc/init.d/mysqld stop
Then, run following command in terminal
# mysqld_safe --skip-grant-tables &
Now login mysql
# mysql -u root mysql
Change root password
mysql > UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit
Now start the mysql daemon service
# /etc/init.d/mysqld start
# mysql -u root -p
I hope , Now you can able to login with root user.
No comments:
Post a Comment