phpMyAdmin cannot connect to MySQL

Hello,

I have just installed yunohost on my VPS. The installation went ok.

I installed phpMyAdmin, but when I click on the tile to access it via the user interface, I receive an error message saying “Cannot connect: invalid settings.”.

I can see through the services panel in the admin interface that mysql is running.

But I have no idea what to do in order to make it work.

Also, when I’m connected to the server in SSH and try to run mysql -u ncollig -p, I alwats get a ERROR 1045 (28000): Access denied for user ‘ncollig’@‘localhost’ (using password: YES). Same with root.

Any help would be really appreciated.

Many thanks in advance for your help.

Best regards,

Nicolas

Try to connect with root user and the password in /etc/yunohost/mysql

mysql -u root -p