Hi Guys,
are there any recent guides on setting up MySQL 5.7 to work with SolidCP?
It seems like the installation for MySQL 5.7 is different than MySQL 5.6 and certain things like allowing remote admin connections are not available as part of options during the installation.
Also not sure if the Connector is required as well and what version works.
Then the setup on SolidCP server panel - not sure if we use the same as website panel.
But for sure any guide for MySQL 5.7 and the connector to make it work for SolidCP would be great. Or should I revert back to MySQL 5.6?
Any help is greatly appreciated.
Hello,
mysql 5.7 is supported by SolidCP since it's first release.
any connector is supported since 1.0.3.
Mysql setup more or less depends on your own plans but in general: make a user similar to root, it doesn't need anything else but localhost --> aslong as you got SolidCP Server installed on the same server.
however i would recommend using hostnames (like mysql1.domain.com)
maybe put them in hosts with 127.0.0.1 for the mysql server it self.
then configure solidcp with that fqdn (this way if you ever migrate, move, upgrade servers you can just move the ip in dns, all sites already use a specific name instead of an ip).
Regards,
Marco
[SOLVED]
Thank-you Marco. Everything worked out.
There was a part in the installation for 5.7 (I used full installation option) - after the files installed, the setup took me to the configuration dialogs. On one of the dialogs, it asks for the "root" password - and under that field, there was another field to add a new user and password. In that field I entered "root" for the user name and the same password I used above and under server IP i left it at default which I believe was "%". I believe that was the field to allow users to access the MySQL through remote ports.
Everything else was just the SolidCP server agent.
