Max User Connection Limit problem after migratin to MariaDB

Support/Development for MySQL, MariaDB, and other database systems
Daniel Bittar
New Forum User
New Forum User
Posts: 3
Joined: Mon Sep 15, 2014 12:22 pm
Location: Brazil

Max User Connection Limit problem after migratin to MariaDB

Unread post 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.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8330
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Max User Connection Limit problem after migratin to Mari

Unread post by scott »

Are you using the mariadb packages from the Atomic repo? They come in two flavors, mariadb and the galera version.
Daniel Bittar
New Forum User
New Forum User
Posts: 3
Joined: Mon Sep 15, 2014 12:22 pm
Location: Brazil

Re: Max User Connection Limit problem after migratin to Mari

Unread post by Daniel Bittar »

Hi Scott!

I'm not! I'm using the official MariaDB repo.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8330
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: Max User Connection Limit problem after migratin to Mari

Unread post by scott »

Which flavor did you use?
Daniel Bittar
New Forum User
New Forum User
Posts: 3
Joined: Mon Sep 15, 2014 12:22 pm
Location: Brazil

Re: Max User Connection Limit problem after migratin to Mari

Unread post 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.
Post Reply