Hi,
Long term user of WSP and pleased to SolidCP supports MariaDB, however I just can't get it configured. A new 2012R2 server,everything installed, trying to configure the MariaDB settings and constantly get -
Could not connect to the specified MariaDB Server:
Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: NO)
I've tested the connection locally using HeidiSQL and command line, as well as remotely. The puzzling thing is "using password: NO" - I am absolutely entering the password (twice) on the SCP config page.
Windows Server 2012R2
MariaDB 10.1
SolidCP 1.1.2
ADO.NET driver 6.9.9
what am I missing? :/
thanks!
David
tried creating and using a different user account than root (testuser) - exact same error, ie it tried with root and no password instead of testuser and the password entered. So appears it's a problem with the form submission?
Hello,
I have tried on our development environment and it appears to work fine.
Are you using a complex password? If you can try something like password in the box to see if it then errors with using password:yes.
Kind Regards,
Trevor Robinson
Hi Trevor,
I've tried with simple passwords (my original had an @ in it, which I thought might be a problem). Even tried setting the passwords to blank and creating new root accounts. Also tried different browsers (Edge & Chrome) and from different machines, as well as via RDP.
ETA:
Turned on query logging on mariadb just to double check, and it confirms - "Connect Access denied for user 'root'@'localhost' (using password: NO)" :/
Just tried setting SCP up on one of our existing servers (this problem install is a new VPS) and it installed and connected to MariaDB just fine .... :/
