MySQL/phpMyAdmin Reset ROOT PASSWORD?

Question

I'm having MySQL on RHEL, and phpMyAdmin interface also. I have normal MySQL user access which i remember but i forget the root password.

How to SAFELY reset the MySQL root password? (I have root account on O/S)

This is answered on serverfault.com : "Lost MySQL password" - http://serverfault.com/questions/287225/lost-mysql-password/287235#287235 — sleske, Feb 05 '13 at 08:44
There're also several dupes heres, I've chosen [a random one](http://stackoverflow.com/questions/4258124/how-to-reset-mysql-root-password) — Álvaro González, Feb 05 '13 at 08:47

score 7 · Accepted Answer · answered Feb 05 '13 at 08:44

7

From Here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Stop mysqld and restart it with the --skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use --skip-grant-tables in conjunction with --skip-networking to prevent remote clients from connecting.

Connect to the mysqld server with this command:

shell> mysql

Issue the following statements in the mysql client. Replace the password with the password that you want to use.

mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
    ->                   WHERE User='root';
mysql> FLUSH PRIVILEGES;

The FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change

answered Feb 05 '13 at 08:44

FreudianSlip

2,870
25
24

In the page, it is saying to stop the service by `pid`. Is it the same as `service mysqld stop` ??? Why using `pid` ? – 夏期劇場 Feb 05 '13 at 08:46
+1 but it requires editing the .pid file (as described in the link) – Najzero Feb 05 '13 at 08:48
So does it mean, `service mysql stop` won't release the `.pid` file?? – 夏期劇場 Feb 05 '13 at 08:49
If you read the section towards the bottom of the page (posted above) you'll see you dont need the pid. – FreudianSlip Feb 05 '13 at 08:52
if you are confused about how to set `--skip-grant-tables` option then please refer my answer @ http://stackoverflow.com/a/24888261/1924296 – Saurabh Hooda Jul 22 '14 at 16:17

score 0 · Answer 2 · answered Jul 20 '14 at 11:09

WINDOWS USERS

For me in wondows 8 this worked; First go to where you installed mysql, I was using wamserver and installed it under D:\Programs\wamp\bin\mysql\mysql5.6.12\bin so cd to that directory, then;

-> mysql UPDATE mysql.user SET Password=PASSWORD('xvpaic7q') -> WHERE User='root'

-> FLUSH PRIVILEGES

MySQL/phpMyAdmin Reset ROOT PASSWORD?

2 Answers2

Linked