MySQL程序安装

1. 安装包的获取(yum安装略)
   https://dev.mysql.com/downloads/mysql/
   2.rpm包安装
   下载rpm包安装：
   注意：该方法安装时，虽然安装包已经下载到了本地，但是在安装的过程中任然可能存在依赖，因此修改安装网络源来接触依赖。
   安装步骤：
   （1）卸载Mariadb

rpm -e mariadb-libs postfix

（2）安装

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -g mysql mysql
[root@localhost ~]# mkdir mysql
[root@localhost ~]# tar xf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar -C mysql
[root@localhost ~]# cd mysql
[root@localhost mysql]# yum localinstall mysql-community-client-8.0.16-
2.el7.x86_64.rpm mysql-community-server-8.0.16-2.el7.x86_64.rpm mysql-community-
libs-8.0.16-2.el7.x86_64.rpm mysql-community-common-8.0.16-2.el7.x86_64.rpm

（3）启动

[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# systemctl enable mysqld

（4）mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式
找到root默认密码，然后登录mysql进行修改：

[root@localhost ~]# grep "temporary password" /var/log/mysqld.log

[root@localhost ~]# mysql -uroot -p #刚才过滤的密码
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.16
Copyright (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 respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user 'root'@'localhost' identified by 'ABC123@com';  #大写，小写，数
字，特殊符号
Query OK, 0 rows affected (0.01 sec)