Posts Tagged ‘mysql’
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
#mysql_upgrade -u [username] -p
#mysqlcheck -u [username] -p --all-databases --check-upgrade --auto-repair
#systemctl restart mysqld
mysql> show events;
Empty set (0.00 sec)
Встановлення MySQL 5.5 на RHEL / CentOS 6 или 5
Для CentOS / RHEL 5 32-64 бит
#rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
Для CentOS / RHEL 6 32-64 бит
#rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
#rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
Для CentOS / RHEL 7 32-64 бит
#wget http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
#rpm -Uvh remi-release-7.rpm
#yum update
#yum –enablerepo=remi install mysql mysql-server