Sep
22 2008
As a database administrator, you might forget the root password for your database. It is a serious problem. This tutorial is to teach you how to reset the root password if you forget it.
#Stop the MySQL service. /etc/init.d/mysql stop #Start the MySQL in the safe mode. mysqld_safe --skip-grant-tables & #Login into MySQL as root user mysql -u root #Update the root user password. mysql> use mysql; mysql> update user set password=PASSWORD("NEW PASSWORD") where user='root'; mysql> flush privileges; mysql> quit; Restart the MySQL service & try to login using the new password. /etc/init.d/mysql stop /etc/init.d/mysql start |
- » [How-to] SVN update using command line
- » [How-to] dump out MySQL Functions, Stored Procedures & Triggers
![[How-to] MySQL function example.](http://www.how2guru.com/wp-content/uploads/2011/08/mysql_function-150x150.png "[How-to] MySQL function example.")
» [How-to] MySQL function example.- » Export mysql select statement into csv
- » MySQL release free disk space.
February 11th, 2009 at 5:44 pm
it’d be safer to go with
mysqld_safe –skip-grant-tables –skip-networking &
April 11th, 2009 at 8:58 pm
here there is no clear answer for this Question, Please Give me clear Answer.
April 11th, 2009 at 9:19 pm
hey its very Clear thanking you Sir,