centos8 yum 安装mysql8

centos8 yum 安装mysql8

1. 获取官方下载地址 https://dev.mysql.com/downloads/repo/yum/

2. 下载mysql安装包 ：wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

3. 将下载好的安装包挂载到本地 找个路径放 cd /home/package
   yum localinstall mysql80-community-release-el8-1.noarch.rpm

4. 查看是否挂载成功
   yum repolist enabled | grep “mysql.-community.”

5. 禁用centos8.0自带的mysql模块
   yum module disable mysql

6. 安装mysql：yum install mysql-community-server

7. 启动mysql服务
   systemctl mysqld start

8. 查看mysql服务启动状态
   systemctl mysqld status

9. 查看mysql安装时生成的随机密码
   grep ‘temporary password’ /var/log/mysqld.log

10. 登录mysql
    mysql -uroot -p’刚获取到的随机密码’

11. 修改登录密码
    ALTER USER ‘root’ @‘localhost’ IDENTIFIED BY ‘您的密码’;
    出现这个问题，表示密码过于简单
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

12. 开放mysql远程访问
    创建权限记录：
    CREATE user ‘root’@’%’ IDENTIFIED BY ‘您的密码’;
    授权：
    GRANT ALL PRIVILEGES ON . TO ‘root’ @’%’ WITH GRANT OPTION;
    修改密码过期策略：
    ALTER USER ‘root’ @‘localhost’ IDENTIFIED BY ‘您的密码’ PASSWORD EXPIRE NEVER;
    重新修改密码：
    ALTER USER ‘root’ @’%’ IDENTIFIED WITH mysql_native_password BY ‘您的密码’;
    刷新权限：
    FLUSH PRIVILEGES;

相关命令

mysql服务相关命令
启动服务：service mysqld start
停止服务：service mysqld stop
重启服务：service mysqld restart
查看服务状态：service mysqld status

设置mysql开机自启：
systemctl enable mysqld
systemctl daemon-reload
查看自启服务
systemctl list-units --type=service