Hi @
cPanelMichael,
There are some features that i like in Percona MySQL, the first is the XtraDB Cluster that has guarantee HA service for years for our customers. There are also some other features like all UDF of percona for control, limit and monitor the users mysql, XtraBackup also it's a very useful function that permit to make snapshot of databases in less time without blocking the db, it also allow to sync a new node of the cluster without do any action on the server.
Well we have now fixed the problem of issue of MySQL 5.7 on cPanel without make any change in cPanel following these steps:
STEP 1 -
Create new column after "user" column
By phpmyadmin:
Name: Password Type: char Size: 41 Encoding: utf8_bin
STEP 2 -
Copy the password from authentication_string
We do that with a simple bash script while we have lot of users
Code:
#!/bin/bash
mysql -e "select user,authentication_string from mysql.user;" > mysql_users.txt
while read line; do
user=$(echo $line | awk '{ print $1 }')
pass=$(echo $line | awk '{ print $2 }')
mysql -e "update mysql.user set Password='$pass' WHERE User='$user';"
done < mysql_users.txt
After this change cPanel will work fine and the websites will also connect to the DB.
Anyway this is a
workaround we made not for production but to downgrade from mysql 5.7 to 5.6 and then to upgrade to MariaDB Galera Cluster.