Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th July 2012, 19:35
bhasina bhasina is offline
Junior Member
 
Join Date: Jul 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default [SOLVED] MySql crashed on upgrade from 10.04 to 12.04 - Ubuntu

Hi,

I recently upgraded my server from Ubuntu 10.04 to 12.04 LTS running Ispconfig 3.0.3.3

Everything went smooth except my MySQL wouldn't work now. I keep getting the following error:

Code:
ERROR 1524 (HY000): Plugin 'none' is not loaded
I get the above error whenever I do

Code:
mysql status
I have tried to do a fresh install of MySQL but it continues to give the same error. I cannot login to the server using

Code:
mysql -u root -p
as it gives the same error.

Any help will be greatly appreciated.

Last edited by bhasina; 9th July 2012 at 19:36. Reason: Forgot to mention Ubuntu
Reply With Quote
Sponsored Links
  #2  
Old 10th July 2012, 08:06
TiTex TiTex is offline
Senior Member
 
Join Date: Aug 2011
Location: Cluj-Napoca,Romania
Posts: 125
Thanks: 0
Thanked 18 Times in 17 Posts
Send a message via Skype™ to TiTex
Default

have you tried to run the mysql_upgrade script after upgrading ?
try
Code:
sudo mysql_upgrade --password=root-password-here
if doesn't let you run the script , start mysql server with --skip-grant-tables
Code:
sudo /usr/sbin/mysqld --skip-grant-tables &
and after that
Code:
sudo mysql_upgrade --force
i think your problem is a bug discussed here http://bugs.mysql.com/bug.php?id=60432

Last edited by TiTex; 10th July 2012 at 08:10.
Reply With Quote
  #3  
Old 12th July 2012, 12:36
bhasina bhasina is offline
Junior Member
 
Join Date: Jul 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks TiTEX but none of it worked. I ended up completely removing mysql with purge and reinstalling. Also had to remove the user data (mysql folder in the data). All up and working now!
Reply With Quote
  #4  
Old 12th July 2012, 12:41
bhasina bhasina is offline
Junior Member
 
Join Date: Jul 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there a way to mark this solved?
Reply With Quote
  #5  
Old 13th July 2012, 16:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

I've added [SOLVED] to the thread title.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 23rd July 2013, 04:11
makoshark makoshark is offline
Junior Member
 
Join Date: Jul 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default solved without sharing

I have tried to purge and reinstall and still have error 1524 Plugin 'none' is not loaded when trying to connect. the last post did not share what and were the files are to delete so I am lost
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ubuntu 11.10 Upgrade to 12.04 - Release Upgrade Tool fails to complete download stuart_88 Installation/Configuration 3 22nd June 2012 23:14
Upgrade from Ubuntu 8.0.4 to 10.04 broke ispconfig2 raymonvdm Installation/Configuration 6 11th February 2012 13:32
Vmware server 2.0.2-x with Ubuntu server 10.04 VMware Remote Console Plug-in letsharehowto HOWTO-Related Questions 12 6th December 2011 21:23
Perfect Server Ubuntu 10.04 webmail issue sidcypher HOWTO-Related Questions 1 5th May 2011 17:11
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 10.04 Kozley HOWTO-Related Questions 4 16th March 2011 19:34


All times are GMT +2. The time now is 16:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.