Tuesday, November 16, 2010

Reset Password in MYSQL

Following commands for get enter into mysql,  without having root privilege

if root privilege incorrect password, change pwd: by following cmd:::

http://www.webhostingtalk.com/showthread.php?t=875255


/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.