Установка MySQL 5.6.22 on CentOS 7/6.6/5.11: различия между версиями

Материал из Webko Wiki
Перейти к навигации Перейти к поиску
(Новая страница: «== 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 #…»)
 
 
Строка 45: Строка 45:
  
 
  /usr/bin/mysql_secure_installation
 
  /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]]
 
[[Категория:DB]][[Категория:Linux]]

Текущая версия на 20:56, 18 июня 2015

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