【centos7 + MySQL5.7 安装】centos7 安装MySQL5.7

分手后的思念是犯贱 2024-03-25 21:43 89阅读 0赞

> 说明：我们安装MySQL位置在 /usr/local 下

### **第一步、下载MySQL 安装包：** ###

[root@localhost local]# wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

安装mysql 安装源：

[root@localhost local]#  yum -y localinstall mysql57-community-release-el7-11.noarch.rpm

### **第二步，在线安装MySQL** ###

[root@localhost local]# yum -y install mysql-community-server

等待时间比较久：

![7e6c657911046e9f6ee055dc8694d951.png][]

### **第三步、启动mysql 服务** ###

[root@localhost local]# systemctl start mysqld

### **第四步，设置开机启动** ###

[root@localhost local]# systemctl enable mysqld
     
    [root@localhost local]# systemctl daemon-reload

### **第五步，修改root登录密码** ###

mysql安装完成之后，会在/var/log/mysqld.log文件中给root生成了一个临时的默认密码。

[root@localhost local]# vim /var/log/mysqld.log

![3a7899e9c7020a4606c721868a783da8.png][]

记住初始密码：

修改root 密码

[root@localhost local]# mysql -u root -p

![0061bb7500c4e0c2852644b29a0bb087.png][]

mysql>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'daasan7ujm^YHN';
    Query OK, 0 rows affected (0.00 sec)
    # 设置远程登录
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'daasan7ujm^YHN' WITH GRANT OPTION;
    Query OK, 0 rows affected, 1 warning (0.00 sec)

第六步，退出

mysql> exit

### **第七步，防火墙开放3306端口** ###

[root@localhost sysconfig]# cd /etc/sysconfig/
    [root@localhost sysconfig]# vim iptables
    #添加代码如下
    -A INPUT -p tcp --dport 3306 -j ACCEPT

![710a69f25dfc680daf952ad2e3c68d7b.png][]

第八步，重启防火墙。

[root@localhost sysconfig]# service iptables  restart

### **第九步，配置mysql默认编码为utf-8** ###

[root@localhost sysconfig]# vim /etc/my.cnf

添加如下代码

character_set_server=utf8
    init_connect='SET NAMES utf8'

![e6c3a89a37faa8969c7e924fa4d9e153.png][]

:wq 保存退出

### **第十步，重启MySQL** ###

[root@localhost data]# systemctl restart mysqld

### **第十一步， root 用户登录查看编码** ###

[root@localhost sysconfig]#  mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.29 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> show variables like '%character%';
    +--------------------------+----------------------------+
    | Variable_name            | Value                      |
    +--------------------------+----------------------------+
    | character_set_client     | utf8                       |
    | character_set_connection | utf8                       |
    | character_set_database   | utf8                       |
    | character_set_filesystem | binary                     |
    | character_set_results    | utf8                       |
    | character_set_server     | utf8                       |
    | character_set_system     | utf8                       |
    | character_sets_dir       | /usr/share/mysql/charsets/ |
    +--------------------------+----------------------------+
    8 rows in set (0.00 sec)
    
    mysql>

最后本地连接测试：

![d18cc3444c852272f7368b0d71096280.png][]

本文链接：[https://blog.csdn.net/EB\_NUM/article/details/105425622][https_blog.csdn.net_EB_NUM_article_details_105425622]

[7e6c657911046e9f6ee055dc8694d951.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/afa803cc3eaa46c6a05ca6290fe284f9.png
[3a7899e9c7020a4606c721868a783da8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/79c10c5c68ac4fbb98d05e7525b84351.png
[0061bb7500c4e0c2852644b29a0bb087.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/2aec5ec0a42741449194308c09f297d4.png
[710a69f25dfc680daf952ad2e3c68d7b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/7007c55befcd438db1fa67f5babbd39d.png
[e6c3a89a37faa8969c7e924fa4d9e153.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/68dc11690aa545ba9e748092814ce99e.png
[d18cc3444c852272f7368b0d71096280.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/3b183d46800b43b78f772361bebc8e1b.png
[https_blog.csdn.net_EB_NUM_article_details_105425622]: https://blog.csdn.net/EB_NUM/article/details/105425622