CentOS安装MySQL
CentOS版本：CentOS 6.8
MySQL版本：mysql-5.7.31-1.el6.x86_64.rpm-bundle.tar
卸载系统中存在的mysql以及mariadb类安装包
rpm ‐qa | grep mysql
rpm ‐qa | grep ‐i mariadb
rpm ‐e ‐‐nodeps mysql‐libs‐5.1.73‐7.el6.x86_64
安装包进行解压
tar ‐xvf mysql‐5.7.31‐1.el6.x86_64.rpm‐bundle.tar ‐C /usr/local/ mysql/
解压后的文件
安装MySQL服务
按照以下顺序进行安装
rpm ‐ivh mysql‐community‐common‐5.7.31‐1.el6.x86_64.rpm
rpm ‐ivh mysql‐community‐libs‐5.7.31‐1.el6.x86_64.rpm
rpm ‐ivh mysql‐community‐client‐5.7.31‐1.el6.x86_64.rpm
rpm ‐ivh mysql‐community‐server‐5.7.31‐1.el6.x86_64.rpm
数据库配置
启动MySQL服务
service mysqld start
获取root初始密码
cat /var/log/mysqld.log | grep root@localhost
登录数据库
使用获取到的密码，登录到数据库中
mysql ‐u root ‐p
修改初始密码
alter user 'root'@'localhost' identified by 'root';
flush privileges;
查看数据库编码
show variables like '%char%';
用户授权
grant all privileges on *.* to 'root'@'%' identified by 'root' w ith grant option;
flush privileges;
修改字符集
vi /etc/my.conf
character_set_server=utf8 2
init_connect='SET NAMES utf8'
保存，然后重启mysql服务
service mysqld restart