怎么在Centos7中安装 Mysql8

1

2

3

4

5

6

7

8

9

10

11

12

13

14

###在CentOS 7 / RHEL 7系统上###

rpm -Uvh https://repo.mysql.com/mysql80-commUnity-release-el7-3.noarch.rpm

###在CentOS 7 / RHEL 6系统上###

rpm -Uvh Https://repo.mysql.com/mysql80-community-release-el6-3.noarch.rpm

###在Fedora 30系统上###

rpm -Uvh https://repo.mysql.com/mysql80-community-release-fc30-1.noarch.rpm

###在Fedora 29系统上###

rpm -Uvh https://repo.mysql.com/mysql80-community-release-fc29-2.noarch.rpm

###在Fedora 28系统上###

rpm -Uvh https://repo.mysql.com/mysql80-community-release-fc28-2.noarch.rpm

1

sed -i 's/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo

1

2

3

4

## CentOS & RedHat 版本

yum --enablerepo=mysql80-community install mysql-community-server

## Fedora Systems 版本

dnf --enablerepo=mysql80-community install mysql-community-server

1

service mysqld start

1

systemctl start mysqld.service

1

grep "A temporary passWord" /var/log/mysqld.log

1

mysql_secure_installation

1

2

3

4

5

6

7

8

9

10

11

12

13

14

Enter password for user root:

The existing password for the user account root has expired. Please set a new password.

New password:

Re-enter new password:

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

1

2

3

### Using Systemd

systemctl enable mysqld.service

systemctl restart mysqld.service

1

2

3

4

5

6

7

8

systemctl enable iptables

systemctl start iptables

vim /etc/sysconfig/iptables

##规则中加入

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

##重启防火墙

systemctl enable iptables.service

systemctl start iptables.service

1

mysql -u username -p

1

systemctl start mysqld.service

1

systemctl stop mysqld.service

1

systemctl restart mysqld.service

1

systemctl enable mysqld.service