Word – WAMP – Reset Root password on thesql

MySQLpassword-recoverywamp

I'm getting this error: access denied for user 'root'@'localhost' using paswword (NO).

Its a fresh install of wampserver 2.2 32 bit.

Is there a way I can reset the mysql root password?

I have tried using mysqld.exe. –init-file=c:\reset.txt (below are the contents)

PDATE mysql.user SET Password=PASSWORD('') WHERE User='root';
FLUSH PRIVILEGES;

Unfortunately this does not work, windows command prompt just hangs.

Any help would be greatly appreciated.

Thanks

Best Answer

It seems that windows is not reading the HOSTS file properly, as a result only 127.0.0.1 is accepted NOT localhost.

To work around this:

Go to your wamp\apps\phpmyadmin.versionnumber\

Open config.inc.php

Change the localhost to 127.0.0.1

Save and restart all services

Related Solutions

Macos – How Do I Reset My Root Password on MySQL on a Mac

Depending on what you're using to run MySQL, you could take a look at the official instructions.

If you're using MAMP or something similar you need to find where mysqladmin is located.

/Applications/MAMP/Library/bin/mysqladmin -u root -p password ’somepassword’

If you are using another installation of mysql, you may be able to find out where it is located with:

$ which mysqladmin

MySQL – How to Fix ‘Access Denied for User root@localhost’

Follow the steps below.

Start the MySQL server instance or daemon with the --skip-grant-tables option (security setting).
```
$ mysqld --skip-grant-tables
```

Execute these statements.

$ mysql -u root mysql
$mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';
$mysql> FLUSH PRIVILEGES;

If you face the unknown field Password error above use:

update user set authentication_string=password('my_password') where user='root';

Finally, restart the instance/daemon without the --skip-grant-tables option.
```
$ /etc/init.d/mysql restart
```

You should now be able to connect with your new password.

$ mysql -u root -p

Enter password: my_password

Fix for MySQL “Unable to lock ibdata1” error

sudo mv /usr/local/mysql/data/ibdata1 /usr/local/mysql/data/ibdata1.bak
sudo mv /usr/local/mysql/data/ib_logfile0 /usr/local/mysql/data/ib_logfile0.bak
sudo mv /usr/local/mysql/data/ib_logfile1 /usr/local/mysql/data/ib_logfile1.bak
sudo cp -a /usr/local/mysql/data/ibdata1.bak /usr/local/mysql/data/ibdata1
sudo cp -a /usr/local/mysql/data/ib_logfile0.bak /usr/local/mysql/data/ib_logfile0
sudo cp -a /usr/local/mysql/data/ib_logfile1.bak /usr/local/mysql/data/ib_logfile1
sudo /etc/init.d/mysql restart

Best Answer

Related Solutions

Macos – How Do I Reset My Root Password on MySQL on a Mac

MySQL – How to Fix ‘Access Denied for User root@localhost’

Fix for MySQL “Unable to lock ibdata1” error

Related Question