linux rpm安装mysql5.7.*密码策略,访问策略等常见问题

逃离我推掉我的手 2023-07-18 12:46 13阅读 0赞

### linux安装mysql5.7.\*密码策略,访问策略相关问题 ###

*  下载mysql
 *   *  依次选择mysql版本.操作系统类型,操作系统版本,下载rpm全套版本
 *  安装mysql
 *   *  上传mysql-5.7.28-1.el7.x86\_64.rpm-bundle.tar文件到/var/tmp并解压
     *  安装mysql
     *  mysql配置文件
     *  启动mysql
     *  修改初始密码
     *   *  查看初始密码(最下面是最新的)
         *  修改密码策略访问策略等

# [下载mysql][mysql] #

## 依次选择mysql版本.操作系统类型,操作系统版本,下载rpm全套版本 ##

![下载mysql][mysql 1]

# 安装mysql #

## 上传mysql-5.7.28-1.el7.x86\_64.rpm-bundle.tar文件到/var/tmp并解压 ##

tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

![解压][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70]

## 安装mysql ##

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-devel-5.7.28-1.el7.x86_64.rpm  
    rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm  
    rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
    rpm -ivh mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm

![安装][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70 1]

## mysql配置文件 ##

cat /etc/my.cnf

![配置][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70 2]

## 启动mysql ##

#查看进程
    ps -ef|grep mysql
    #查看状态
    service mysqld status
    #启动msyql
    service mysqld start

![启动mysql][mysql 2]

## 修改初始密码 ##

### 查看初始密码(最下面是最新的) ###

cat /var/log/mysqld.log |grep root@localhost

![查看初始密码][20200330152537166.png]

### 修改密码策略访问策略等 ###

#连接mysql并输入密码
    mysql -u root -p
    #修改初始化密码
    ALTER USER USER() IDENTIFIED BY 'TESTtest1234.';
    #设置密码策略
    set global validate_password_policy=0;
    set global validate_password_length=1;
    #使用mysql表
    use mysql;
    #修改密码
    update mysql.user set authentication_string=password('root') where user='root';
    #修改远程访问ip
    update user set host = '%' where user ='root';
    #刷新
    flush privileges;
    #退出
    quit;

![修改策略][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70 3]

[mysql]: https://downloads.mysql.com/archives/community/
[mysql 1]: /images/20230528/97682fa511cb4a2c92e2291c479db8a1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70]: /images/20230528/6aff47b827dc497bad10fec0fbfd8397.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70 1]: /images/20230528/987e0698c5e542319525a82abaea56ea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70 2]: /images/20230528/f0f1957f227b43e4867ee6903a9284e7.png
[mysql 2]: /images/20230528/6d857e5dfa69479ca7048d79f2fcbc6d.png
[20200330152537166.png]: /images/20230528/7564dddcc8c141bebb01117a83cdc68f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70 3]: /images/20230528/683c3630744a4ec6b939704e5025cf49.png