清除自带的mariadb
> rpm -qa|grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64
> rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
下载并解压缩 mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
> tar zvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
> ls -l
-rw-r--r--. 1 root root 607068160 6月 24 10:12 mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 33432660 5月 3 12:38 mysql-community-client-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 588520 5月 3 12:38 mysql-community-common-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 5712552 5月 3 12:38 mysql-community-devel-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 24493344 5月 3 12:38 mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 3127296 5月 3 12:38 mysql-community-libs-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 2177156 5月 3 12:38 mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 422672748 5月 3 12:39 mysql-community-server-8.0.16-2.el7.x86_64.rpm-rw-r--r--. 1 7155 31415 114848996 5月 3 12:40 mysql-community-test-8.0.16-2.el7.x86_64.rpm
开始依次安装:
> yum install -y mysql-community-common-8.0.16-2.el7.x86_64.rpm
> yum install -y mysql-community-libs-8.0.16-2.el7.x86_64.rpm
> yum install -y mysql-community-devel-8.0.16-2.el7.x86_64.rpm
> yum install -y mysql-community-client-8.0.16-2.el7.x86_64.rpm
> yum install -y mysql-community-server-8.0.16-2.el7.x86_64.rpm
启动mysql
> service mysqld start
Redirecting to /bin/systemctl start mysqld.service
修改默认的root密码。
可以在日志文件中找到初始密码:
> grep
'temporary password'
/var/log/mysqld
.log
2019-06-24T02:32:21.735405Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ts?7L9#reubW
登录mysql
mysql -h127.0.0.1 -uroot -pts?7L9#reubW
mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 10Server version: 8.0.16Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
修改root密码:
mysql>
set
global validate_password_policy=0;
mysql> set
global validate_password_length=1;
mysql> ALTER USER
'root'
@
'localhost'
IDENTIFIED BY
'Abc@123'
;
mysql> GRANT ALL PRIVILEGES ON *.* TO
'root'
@
'%'
IDENTIFIED BY
'Abc@123'
WITH GRANT OPTION;FLUSH PRIVILEGES;
mysql> quit
重启服务
> service mysqld restart