Firstly apologies but I am very new to both phpMyAdmin and mySQL.
I set up the newest version of XAMPP and set up a mySQL database called test and filled it with data.
When I was attempting to link it up with php through phpMyAdmin I decided to set a password. I went for something easy 'root'.
My first error was after changing the password it immediately kicked me out of phpMyAdmin saying this
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
After reading up on a few forums I realised it was a problem with the config.inc and so I changed
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
in config.inc to
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
this let me in to phpMyAdmin but only so far if I attempted to go into my database 'test' it wouldn't let me any further giving me another error. Noticing 'pma' the other user had no password as well and you could set the password through mySQL, I tried to use this method to change the password back for.
Unfortunately now it won't let me into anything I have tried editing the config.inc to original state and changing the password fields.
This error appears:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
It is set up on a localserver.
Please advise and thank you for your time.