WampServer

For unknown reason my root password is changed of my mysql server

I have no idea what the root password is, how can I reset it?

If I open the mysql console it directly response with an password, if I just give enter it closes and I barely can see that it writes: wrong password.

So how can I reset the password?

if you had done a simple seach, you would have found my post here yesterday about changing/editing your mysql root users password.
[forum.wampserver.com]

CyberSpatium
WAMP English Forum Admin

That is not that simple as you suggest.

First I do not knopw the present password.
second I cannot login into PHPMyadmin because it reports that there is a wrong password for user root.

So how do I reset the root password If I cannot login as root anymore?

you have edited the phpmyadmin conf file and changed the root users password. you can not just add any password you want. mysql comes with the root user set with no password, so you need to edit your password setting and change it back to:
$cfg['Servers'][$i]['password'] = '';

now log back into phpmyadmin and then follow my instructions to add a password for the root user, then update the $cfg['Servers'][$i]['password'] setting with your new password.

You don't understand, I do not know the root password at all and I cannot change it either.

For unknown reason the root password is changed, maybe someone change it or an other application which uses also mysql changed it.
The fact is that I do not know the current root password at all
I myself did not change it, the problem now is I cannot access the mysql database anymore as root user, the mysql works normal, site users work only root does not work anymore.

So I cannot acces it using phpmyadmin with user root, I have no idea what password to fill in in the config file. When I leave it blank phpmyadmin errors, when I use the last known password of root it also errors with wrong password!

I allready tried the reset root password as descriped on www.mysql.com but for unknown reason this does not work with the wamp edition.

So again, how can I reset the root password if I have no idea what thge current root password is? (the root password is NOT blank/empty)

again, mysql comes with the root user set with no password.

CyberSpatium
WAMP English Forum Admin

Yes and that none set password is now set with a password and I do not know what that password is!
So how do I remove the password or change it if i dont know what it is?

you need to know your root user's password to be able to use the mysql console or phpmyadmin to change it. if you do not know the password,you need to uninstall wamp and install it again.

CyberSpatium
WAMP English Forum Admin

if you have another username / password, like it sounds like you do, then you can go to
C:\wamp\phpmyadmin\config.ini and at about like 72 there is
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
if you know another password / username change the top line (72) to the username and the line under it to the password. then it will look like
$cfg['Servers'][$i]['user'] = 'new_user'; // MySQL user
$cfg['Servers'][$i]['password'] = 'new_password'; // MySQL password (only needed

after you do that, open phpmyadmin and then cange the root password back to blank. if that works, you can choose to either reset the .ini back to the root user or leave it how it is.

hope this helps

you can only change passwords if the user you use has administrative privileges.

CyberSpatium
WAMP English Forum Admin

As said there is an other password but I do not know it.

Never mind this problem, I reinstalled the mysql so this problem is solved now