Page 1 of 1

Max User Connection Limit problem after migratin to MariaDB

Posted: Mon Sep 15, 2014 1:17 pm
by Daniel Bittar
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.

Re: Max User Connection Limit problem after migratin to Mari

Posted: Mon Sep 15, 2014 6:03 pm
by scott
Are you using the mariadb packages from the Atomic repo? They come in two flavors, mariadb and the galera version.

Re: Max User Connection Limit problem after migratin to Mari

Posted: Mon Sep 15, 2014 6:24 pm
by Daniel Bittar
Hi Scott!

I'm not! I'm using the official MariaDB repo.

Re: Max User Connection Limit problem after migratin to Mari

Posted: Tue Sep 16, 2014 9:44 am
by scott
Which flavor did you use?

Re: Max User Connection Limit problem after migratin to Mari

Posted: Tue Sep 16, 2014 9:52 am
by Daniel Bittar
Hi Scott!

I'm using version 5.5.39 x86_64. However I've found the solution. I had to start the service with --skip-grant-tables and do the mysql_upgrade. After that I restarted and it was working.

Thanks a lot,
Daniel Bittar.