Hi
We recently migrated our Solid CP server (Running mysql 5.7) over to a new server running mysql 8.0
It seems creating a Database is fine. However, it throws an error when trying to create a mySQL User.
The error in the event logs is as follows:
ERROR: 'MySQL Server 5.7' CreateUser
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'XXXXXXXXX'' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
Where XXXXXXXXX was the password we used. Removed for security reasons.
Please, this is super urgent. Your urgent response is appreciated.
I have a feeling this might be related to the error being thrown. I hope this helps you in finding the answer.
https://stackoverflow.com/questions/50409788/mysql-8-create-new-user-with-password-not-working
Hi Guys
Just an update.
What we ended up doing is reverting to an instance of MySQL 5.7 by installing a binary version.
Hopefully, SolidCP adds support for MySQL 8.0 sometimes soon 🙂
Thanks
