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.
Max User Connection Limit problem after migratin to MariaDB
-
- New Forum User
- Posts: 3
- Joined: Mon Sep 15, 2014 12:22 pm
- Location: Brazil
-
- Atomicorp Staff - Site Admin
- Posts: 8355
- Joined: Wed Dec 31, 1969 8:00 pm
- Location: earth
- Contact:
Re: Max User Connection Limit problem after migratin to Mari
Are you using the mariadb packages from the Atomic repo? They come in two flavors, mariadb and the galera version.
-
- 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
Hi Scott!
I'm not! I'm using the official MariaDB repo.
I'm not! I'm using the official MariaDB repo.
-
- Atomicorp Staff - Site Admin
- Posts: 8355
- Joined: Wed Dec 31, 1969 8:00 pm
- Location: earth
- Contact:
Re: Max User Connection Limit problem after migratin to Mari
Which flavor did you use?
-
- 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
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.
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.