Sunday, 3 August 2014

mysql 5.0-5.6 upgrade error

InnoDB: Recalculation of persistent statistics requested for table "roundcubemail"."session" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead"

 

between 5.0/5.1 and 5.5/5.6 they did some major re-working of the internal structure of the mysql main database. 

 

run commands to verify and then restart it in a safe mode.

so pretty much service mysqld stop, mysqld_safe, service mysqld stop, service mysqld start

 


ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

This will happen usually when you upgrade from 5.0/5.1 to 5.5 or higher.


So, first thing, shutdown mysql:

shell> service mysqld stop

Then, check if the files / folders in your mysql directory have been changed to own by root, this happened with us.

NB DO THIS FIRST
shell> chown -R mysql.mysql /var/lib/mysql

Then restart and tell it to not worry about privileges / permissions:

shell> sudo mysqld --skip-grant-tables &

You will then be able to login without a username / password:

shell> mysql

mysql> UPDATE mysql.user SET Password=PASSWORD(’NEW_PASSWORD') where User='root’;

mysql> FLUSH PRIVILEGES;

Stop Mysql and start it up again normally (not with the skip-grant tables)
shell> service mysqld stop

shell>sudo service mysqld start

Your new password should now work.

Then, run the command:

shell> mysql_upgrade -u root -p

this will check your tables and fix most problems, watch the output and make sure all is okay.

 

php 7 nightmare

OK so Centos 6 insists on installing php 5.3 and even if you download other RPMs and install them, they do not replace the existing 5.3 whic...