innodb_strict_mode=0
innodb_use_native_aio=0

mysqldump --opt --system=users --insert-ignore --all-databases > /root/sql.sql

sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_general_ci/g' *.sql
mysql --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql --skip-column-names -A | sed 's/$/;/g' > user_grants.sql;
mysql --skip-column-names -A mysql -e "SELECT CONCAT('CREATE USER \'', user, '\'@\'', host, '\' IDENTIFIED WITH \'mysql_native_password\' AS \'', authentication_string,'\';') FROM mysql.user WHERE user NOT IN ('mysql.session','mysql.sys','debian-sys-maint','root');" > create_user.sql;
mysql < create_user.sql;
mysql < user_grants.sql;
for user in `/bin/ls -A /var/cpanel/users` ; do /usr/local/cpanel/bin/restoregrants --cpuser $user --db=mysql --all; done