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