Просмотр кода страницы Установка MySQL 5.6.22 on CentOS 7/6.6/5.11

== Install MySQL YUM repository ==

 ## CentOS 7 and Red Hat (RHEL) 7 ##
 yum localinstall http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
  
 ## CentOS 6 and Red Hat (RHEL) 6 ##
 yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
  
 ## CentOS 5 and Red Hat (RHEL) 5 ## 
 yum localinstall http://dev.mysql.com/get/mysql-community-release-el5-5.noarch.rpm

== Update or Install MySQL 5.6.22 ==

 yum install mysql-community-server

== Start MySQL server and autostart MySQL on boot ==

CentOS 7

 systemctl start mysql.service ## use restart after update
  
 systemctl enable mysql.service

CentOS 6.6/5.11 and Red Hat (RHEL) 6.6/5.11

 /etc/init.d/mysqld start ## use restart after update
 ## OR ##
 service mysqld start ## use restart after update
 
 chkconfig --levels 235 mysqld on

== MySQL Secure Installation ==

-Set (Change) root password

-Remove anonymous users

-Disallow root login remotely

-Remove test database and access to it

-Reload privilege tables

Start MySQL Secure Installation with following command

 /usr/bin/mysql_secure_installation

== MySQL upgrade db ==

 mysql_upgrade -u -p  --no-defaults --check-upgrade --all-databases --auto-repair
or
 mysqlcheck --no-defaults --check-upgrade --all-databases --auto-repair
[[Категория:DB]][[Категория:Linux]]