Apache Friends Support Forum

HELLO MY Phpmyadmin was error? What was the problem. I really need help

imnobody wrote:I really need help

This is quite impossible without any hint.

"My TV does error - need help"....

Maybe he/she means that phpMyAdmin throws Access denied (which I have currently, unsolved)?
It says:

Welcome to phpMyAdmin

Error

MySQL said: Documentation
Cannot connect: invalid settings.
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.

However, I can work on my localhost sites as per usual.
This is XAMPP 5.6.12 fresh installation with no changes to defaults, on Win 7 Ultimate 64-bit.
Just re-installed my 15+ sites from backups and everything else is just OK.

Also Windows Event Viewer gives a few MySQL warnings about deprecated features (about TIMESTAMP & key_buffer_size), which I haven't seen before.

No intention to hijack topic, just seems similar enough.

Any ideas how to investigate further, would be nice to connect to my dbs via phpMyAdmin, too?

OK, figured this out - I edited manually file xampp/phpMyAdmin/config.inc.php line 21 from

Code: Select all

$cfg['Servers'][$i]['password'] = '';

to

Code: Select all

$cfg['Servers'][$i]['password'] = 'mypassword';

ripley wrote:This is XAMPP 5.6.12 fresh installation with no changes to defaults, on Win 7 Ultimate 64-bit.

So this cannot be true. By default there is no password set.