He left me and went somewhere and asked me to solve the problem before I left.
During this i requited the mysql root password, but he want there. So i googled to reset the mysql password. And here is what i did to reset the password.
$ sudo /etc/init.d/mysql stop
$ sudo mysqld_safe --skip-grant-tables --user=root
$ sudo mysql -u root
$ sudo mysqld_safe --skip-grant-tables --user=root
$ sudo mysql -u root
Run this query in mysql prompt:
mysql> UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
Finally kill this mysql process and restart it safely:
$ sudo /etc/init.d/mysql start
ref: http://www.linuxweblog.com/blogs/sandip/20060330/reset-mysql-root-password
No comments:
Post a Comment