The following error appears on attempt to connect databases on OBAS server remotely:
15:13:11 Error loading schema content Error Code: 1558 Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50166, now running 50173. Please use mysql_upgrade to fix this error.
mysql.proc has incorrect schema (was not upgraded during MySQL upgrade).
Create databases backups:
# mkdir /root/mysql_backups/ # mysql -Ne"show databases"|grep -v information_schema|while read db;do mysqldump $db > /root/mysql_backups/$db.`date +%F_%H.%M`.sql;done
Make sure that mysql.proc was upgraded and has 20 columns:
# mysql mysql -Nse "desc proc" | wc -l 20