[SOLVED] MySql crashed on upgrade from 10.04 to 12.04 - Ubuntu

[bhasina]

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:

ERROR 1524 (HY000): Plugin 'none' is not loaded

I get the above error whenever I do

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

mysql -u root -p

as it gives the same error.

Any help will be greatly appreciated.

[TiTex]

have you tried to run the mysql_upgrade script after upgrading ?
try

sudo mysql_upgrade --password=root-password-here

if doesn't let you run the script , start mysql server with --skip-grant-tables

sudo /usr/sbin/mysqld --skip-grant-tables &

and after that

sudo mysql_upgrade --force

i think your problem is a bug discussed here http://bugs.mysql.com/bug.php?id=60432

[bhasina]

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]

Is there a way to mark this solved?

[falko]

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