1.1 centos安装mysql5.7

 

安装配置mysql
1.下载源安装包：wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2.安装源：yum localinstall mysql57-community-release-el7-8.noarch.rpm
3.安装mysql：yum install mysql-community-server
4.启动mysql：systemctl start mysqld
5.启动状态：systemctl status mysqld
5.开机启动：systemctl enable mysqld           systemctl daemon-reload
6.修改密码：
（1）找默认密码：grep 'temporary password' /var/log/mysqld.log
（2）登录：mysql -uroot -p
（3）设新密码：set password for 'root'@'localhost'=password('MyNewPass4!'); 
7.设置mysql编码
（1）打开/etc/my.cnf
（2）添加配置
     [mysqld]
     character_set_server=utf8
     init_connect='SET NAMES utf8'
8.重启mysql：systemctl restart mysqld

配置文件：/etc/my.cnf  
日志文件：/var/log//var/log/mysqld.log  
服务启动脚本：/usr/lib/systemd/system/mysqld.service  
socket文件：/var/run/mysqld/mysqld.pid