Linux Servers

Install MySQL 5.5.46 on Centos 6.3, 6.5

1. Install Remi repository (as root)  cd /etc/yum.repos.d/ ## Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 ## rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm ## CentOS 5 and Red Hat (RHEL) 5 ## rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 2. Update to MySQL 5.5.46 yum –enablerepo=remi,remi-test list mysql…

Fix Column count of mysql.db is wrong. Expected 22, found 20 – centos

1. service httpd stop 2. service mysqld stop 3. edit /etc/my.cnf under [mysqld], add the following line: skip-grant-tables [mysqld] skip-grant-tables 4. service mysqld start 5. run command mysql_fix_privilege_tables –verbose –password=MYSQLPASSWORD 6. edit /etc/my.cnf comment out line #skip-grant-tables 7. stop and start mysqld service mysqld stop service mysqld start 8. start…