Установка MySQL 5.6.22 on CentOS 7/6.6/5.11: различия между версиями
Перейти к навигации
Перейти к поиску
Sol (обсуждение | вклад) (Новая страница: «== 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 #…») |
Sol (обсуждение | вклад) |
||
Строка 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