HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   [SOLVED] MySql crashed on upgrade from 10.04 to 12.04 - Ubuntu (http://www.howtoforge.com/forums/showthread.php?t=57869)

bhasina 9th July 2012 19:35

[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.

TiTex 10th July 2012 08:06

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

bhasina 12th July 2012 12:36

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!

bhasina 12th July 2012 12:41

Is there a way to mark this solved?

falko 13th July 2012 16:28

I've added [SOLVED] to the thread title. :)

makoshark 23rd July 2013 04:11

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


All times are GMT +2. The time now is 03:51.

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