mysql单机安装-centos

短命女 2023-05-28 05:25 8阅读 0赞

1.  进入官网`https://dev.mysql.com/downloads/`，选择MySQL Yum Repository，下载合适自己系统的版本 `wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm`
2.  安装 `sudo rpm -ihv mysql80-community-release-el7-3.noarch.rpm`
3.  yum安装 `sudo yum install mysql-community-server`
4.  修改密码，远程登录

查看密码

[root@xhx151 lib]# cat /var/log/mysqld.log |grep password
    2019-12-28T22:19:56.048362Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Pp.3WDzRVIe=

修改密码，权限

mysql> set global validate_password.policy=0;
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'xuhaixing';
    Query OK, 0 rows affected (2.81 sec)
    
    mysql> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> select user, host from user;
    +------------------+-----------+
    | user             | host      |
    +------------------+-----------+
    | mysql.infoschema | localhost |
    | mysql.session    | localhost |
    | mysql.sys        | localhost |
    | root             | localhost |
    +------------------+-----------+
    4 rows in set (0.00 sec)
    
    mysql> update user set host='%' where user = 'root';
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> select user, host from user;
    +------------------+-----------+
    | user             | host      |
    +------------------+-----------+
    | root             | %         |
    | mysql.infoschema | localhost |
    | mysql.session    | localhost |
    | mysql.sys        | localhost |
    +------------------+-----------+
    4 rows in set (0.00 sec)
    
    mysql>

**实时内容请关注微信公众号，公众号与博客同时更新：程序员星星**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIzMjY0NjI_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIzMjY0NjI_size_16_color_FFFFFF_t_70]: /images/20230528/6c02c55a518d4b7ba6f17dc7152ad73b.png