CentOS7下MySQL5.7的安装

1、下载MySQL 安装包&＃xff1a;

• wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
• yum -y localinstall mysql57-community-release-el7-11.noarch.rpm

2、在线安装MySQL

• yum -y install mysql-community-server

3、启动mysql 服务

• systemctl start mysqld

4、设置开机启动

• systemctl enable mysqld
• systemctl daemon-reload

5、修改root登录密码

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

2020-07-21T06:45:28.566414Z 1 [Note] A temporary password is generated for root&＃64;localhost: TxUa>Lh>D7B!


• 记住初始密码&＃xff0c;修改root 密码&＃xff1a;mysql -u root -p
• ALTER USER &＃39;root&＃39;&＃64;&＃39;localhost&＃39; IDENTIFIED BY &＃39;新密码&＃39;
• #设置远程登录GRANT ALL PRIVILEGES ON *.* TO &＃39;root&＃39;&＃64;&＃39;%&＃39; IDENTIFIED BY &＃39;新密码&＃39; WITH GRANT OPTION;

6、退出

• exit

7、配置mysql默认编码为utf-8

• vim /etc/my.cnf添加如下代码

character_set_server&＃61;utf8
init_connect&＃61;&＃39;SET NAMES utf8&＃39;


• systemctl restart mysqld重启mysql
• 进入mysql使用show variables like &＃39;%character%&＃39;;查看编码格式&＃xff01;