选择mysql软件版本

centos内核版本属于Redhat系列，这里选择Redhat Linux，选择mysql-community-server-5.7.28-1.el7.x86_64.rpm
image.png

下载mysql发行包

  1. wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-common-5.7.28-1.el7.x86_64.rpm
  2. wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-libs-5.7.28-1.el7.x86_64.rpm
  3. wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-client-5.7.28-1.el7.x86_64.rpm
  4. wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-server-5.7.28-1.el7.x86_64.rpm

image.png
image.png

安装下载的发行包，需要先安装依赖包，我这边安装基础依赖包

centos预先安装了mariadb 可以先卸载，使用 yum list | grep mariadb 可以查看安装包,使用yum remove mariadb-libs

  1. ## 安装命令
  2. yum -y install xxxx.rpm

mysql启动重启停止命令

  1. systemctl start mysqld         ## 启动
  2. systemctl restart mysqld     ## 重启
  3. systemctl stop mysqld         ## 停止

第一次使用预制密码进入root

  1. ## 找到启动日志打印的密码
  2. grep 'temporary password' /var/log/mysqld.log
  4. ## 如果不小心删除或者没有打印，可以临时修改my.cnf停用密码验证
  5. ##添加
  6. skip-grant-tables
  8. ## 重启
  9. systemctl restart mysqld

修改root密码和远程访问

  1. ## 进入mysql控制台，修改密码，重启即可
  2. ALTER user root@localhost IDENTIFIED BY 'xxxx';
  3. flush privileges; ##刷新权限
  5. ## 如果提示密码简单，修改密码强度检验器的校验强度,密码安全策略，
  6. ## 默认MEDIUM策略,生产还是建议设置强度大的密码
  7. show variables like 'validate_password%';
  8. set global validate_password_policy = 'LOW'
  11. ## 设置允许远程连接
  12. use mysql;
  13. update user set Host = '%' where User = 'root'

image.png

新建用户和分配权限

  1. CREATE USER `test`@`%` IDENTIFIED BY '123456';
  3. GRANT Alter, Create, Index, Insert, Select, Update ON *.* TO `test`@`%`;