Max User Connection Limit problem after migratin to MariaDB
Posted: Mon Sep 15, 2014 1:17 pm
Hi there!
I was trying to migrate a cPanel server from MySQL to MariaDB 5.5.39 following this guide: http://blog.cpanel.net/mysql-mariadb/
After the migration, upon executing the comand mysql_upgrade I got the following error:
--------------------------------------
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1226 (42000): User 'root' has exceeded the 'max_user_connections' resource (current value: -1)
FATAL ERROR: Upgrade failed
--------------------------------------
I read a lot and tryed several fixes but none worked. I've updated my.cnf file with max_user_connections and restart MariaDB but it didn't work. And as I can't login as root I can't grant it a higher value of it. And nothing I do seems to make a difference in "max_user_connections current value: -1".
How can I fix this?
Thanks a lot,
Daniel Bittar.
I was trying to migrate a cPanel server from MySQL to MariaDB 5.5.39 following this guide: http://blog.cpanel.net/mysql-mariadb/
After the migration, upon executing the comand mysql_upgrade I got the following error:
--------------------------------------
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1226 (42000): User 'root' has exceeded the 'max_user_connections' resource (current value: -1)
FATAL ERROR: Upgrade failed
--------------------------------------
I read a lot and tryed several fixes but none worked. I've updated my.cnf file with max_user_connections and restart MariaDB but it didn't work. And as I can't login as root I can't grant it a higher value of it. And nothing I do seems to make a difference in "max_user_connections current value: -1".
How can I fix this?
Thanks a lot,
Daniel Bittar.