Hi,
I am constantly getting errors after upgrading to mysql 5.7. I was hesitant that after the upgrade I will end up with errors and my nightmares became true. I upgraded and now whenever I try to goto mysql in cpanel I get the following:
---
The MySQL server is currently offline.
Error while connecting to MySQL: (XID ezmaex) The system failed to connect to the “MySQL” database “mysql” because of an error: ER_ACCESS_DENIED_ERROR (Access denied for user 'root'@'localhost' (using password: YES)) Error while connecting to MySQL: (XID ezmaex) The system failed to connect to the “MySQL” database “mysql” because of an error: ER_ACCESS_DENIED_ERROR (Access denied for user 'root'@'localhost' (using password: YES)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 397, <STDIN> line 1.
---
mysql is up and running and sites are also working, only that when I try to access mysql in cpanel I get the above.
When I try to run "mysql" in ssh i get another error:
---
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
---
What is happening ? How do I fix this ????
Please help.
Thanks.
I am constantly getting errors after upgrading to mysql 5.7. I was hesitant that after the upgrade I will end up with errors and my nightmares became true. I upgraded and now whenever I try to goto mysql in cpanel I get the following:
---
The MySQL server is currently offline.
Error while connecting to MySQL: (XID ezmaex) The system failed to connect to the “MySQL” database “mysql” because of an error: ER_ACCESS_DENIED_ERROR (Access denied for user 'root'@'localhost' (using password: YES)) Error while connecting to MySQL: (XID ezmaex) The system failed to connect to the “MySQL” database “mysql” because of an error: ER_ACCESS_DENIED_ERROR (Access denied for user 'root'@'localhost' (using password: YES)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 397, <STDIN> line 1.
---
mysql is up and running and sites are also working, only that when I try to access mysql in cpanel I get the above.
When I try to run "mysql" in ssh i get another error:
---
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
---
What is happening ? How do I fix this ????
Please help.
Thanks.