Editing Mysql root passwd


[[Category:'''FORGET MYSQL ROOT PASSWORD''' ]] 

1.Stop the mysql server.

/etc/init.d/mysqld stop

2.Start the mysql daemon with  –skip-grant-tables option.
--
 mysqld_safe --skip-grant-tables&

3.Login to the server as root user.

[root@alpha ~]# mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.
our MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
4.Reset the mysql root password using the following commands.
--
 mysql> use mysql;
 mysql> update user set password=PASSWORD("New root pass") where User='root';
 mysql> flush privileges;
 mysql> quit
--
« Dispersed Storage
Adding multiple virtual network interfaces in Ubuntu »
Reset mysql root password

Sometimes in some situations we forget some important things in their life LOL.So today I’m gonna share how to reset the reset the mysql root password.The steps are here.

1.Stop the mysql server.

/etc/init.d/mysqld stop

2.Start the mysql daemon with  –skip-grant-tables option.

mysqld_safe --skip-grant-tables&

3.Login to the server as root user.

[root@alpha ~]# mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.

our MySQL connection id is 1

Server version: 5.0.77 Source distribution

 

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 

mysql>

4.Reset the mysql root password using the following commands.

mysql> use mysql;

mysql> update user set password=PASSWORD("New root pass") where User='root';

mysql> flush privileges;

mysql> quit

5.Stop the mysql daemon and start it again.
/etc/init.d/mysqld stop

/etc/init.d/mysqld start

--[[User:Subhash|Subhash]] 12:52, 29 September 2012 (IST)