Hello, I am new to EE and having a issue. Clean Ubuntu 14.04 VPS, used EE install command and made a generic site manually with no problem, but anything I try to make that would use a mysql DB fails with a error: ‘MySQL Connectivity problem occured’ “Oops Something went wrong !!”
Checked mysql error log and saw the normal: [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)
Alas here is the issue I can tell why. I verified the password files are all there, as well as mysql command auto logs in:
root@ubuntu:/# cat /root/.my.cnf
[client]
user=root
password="password"
root@ubuntu:/# cat ~/.my.cnf
[client]
user=root
password="password"
root@ubuntu:/# cat /etc/mysql/conf.d/my.cnf
[client]
user = root
password = "password"
root@ubuntu:/# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 165
Server version: 10.1.8-MariaDB-1~trusty-log mariadb.org binary distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
So I am not sure where EE is getting the wrong password for the MYSQL database. Anywhere else I should be checking, or any suggestions at all to fix this issue would be truly appreciated.
Thanks!