CentOS安装MySQL

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