store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Sat Oct 19, 2019 6:52 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Max User Connection Limit problem after migratin to MariaDB
Unread postPosted: Mon Sep 15, 2014 1:17 pm 
Offline
New Forum User
New Forum User

Joined: Mon Sep 15, 2014 12:22 pm
Posts: 3
Location: Brazil
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.


Top
 Profile  
Reply with quote  
 Post subject: Re: Max User Connection Limit problem after migratin to Mari
Unread postPosted: Mon Sep 15, 2014 6:03 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
Are you using the mariadb packages from the Atomic repo? They come in two flavors, mariadb and the galera version.


Top
 Profile  
Reply with quote  
 Post subject: Re: Max User Connection Limit problem after migratin to Mari
Unread postPosted: Mon Sep 15, 2014 6:24 pm 
Offline
New Forum User
New Forum User

Joined: Mon Sep 15, 2014 12:22 pm
Posts: 3
Location: Brazil
Hi Scott!

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


Top
 Profile  
Reply with quote  
 Post subject: Re: Max User Connection Limit problem after migratin to Mari
Unread postPosted: Tue Sep 16, 2014 9:44 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
Which flavor did you use?


Top
 Profile  
Reply with quote  
 Post subject: Re: Max User Connection Limit problem after migratin to Mari
Unread postPosted: Tue Sep 16, 2014 9:52 am 
Offline
New Forum User
New Forum User

Joined: Mon Sep 15, 2014 12:22 pm
Posts: 3
Location: Brazil
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.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group