创建文件夹/opt/mysql

 
mkdir /opt/mysql
wget http://dev.mysql.com/get/   下载网址
tar -zxvf 目标
 
rpm -qa|grep mari
 
rpm -qa|grep 后面跟服务查询本机是否会有此服务的程序
rpm -e --nodeps mariadb-libs 卸载
rpm -qa|grep mari 卸载后再次查

安装下面的软件

[
root@localhost mysql]# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

启动mysql

运行systemctl start mysqld.service,

然后设置root 用户密码
Mysql自动给root用户设置，随机密码，运行，

grep"password" /var/log/mysqld.log

使用root用户登录。

mysql -u root -p

个人开发环境可以运行，

set global validate_password_policy=0；可以提示密码设置策略，validate_password_policy默认值1

set passsword for 'root'@'localhost' =password('hspedu100')；

运行flush privileges 使密码生效。

flush privileges

quit

退出生效

yum 安装

https://www.cnblogs.com/diantong/p/10962705.html
下载mysql5.7.26安装包
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
 wget http://192.168.1.159/mysql5.726/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

83  yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio libaio-devel net-tools
   85  rpm -qa | grep mariadb

yum -y remove mariadb-libs
   86  ls
   87  mkdir msyql
   88  mv mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar msyql/
   89  ls
   90  mv msyql mysql
   91  cd mysql/
   92  ls
   93  tar xf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar 
   94  ls
   95  yum install  mysql-community-server-5.7.26-1.el7.x86_64.rpm mysql-community-common-5.7.26-1.el7.x86_64.rpm mysql-community-libs-5.7.26-1.el7.x86_64.rpm mysql-community-client-5.7.26-1.el7.x86_64.rpm
   96  systemctl start mysqld
   97  systemctl enable mysqld
   98  systemctl status mysqld
   99  grep "password" /var/log/mysqld.log
  100  mysql -uroot -p"o-krEwzy6_sq"

 
 
set global validate_password_length=1;
set global validate_password_policy=0;
set password for root@localhost = password('123456');
flush privileges;
 
```language
mysql> set password for 'root'@'%'=password('xxxxx');
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 
 
 
update user set host = '%'  where user = 'root';
flush privileges;
select Host,User from user;
 

 或者这样授权

GRANT ALL PRIVILEGES ON *.* TO 'mycat'@"192.168.1.%" IDENTIFIED BY "123456"