linux安装mysql

清理环境

centos7会自带一个mariadb

查看是否已安装

rpm -qa |grep -i mysql
rpm -qa |grep -i mariadb（centos7默认系统自带的）
mysql会和mariadb冲突

删除mariadb

rpm -e mariadb-libs-5.5.56-2.el7.x86_64

按照顺序安装rpm软件包

rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
yum install net-tools
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm

启动mysql

systemctl start mysqld

开机自启

systemctl enable mysqld

更改密码

1.查看初始密码
cat /var/log/mysqld.log | grep passward
2.启动mysql执行命令更改密码
set password for 'root'@'localhost'=password('xxxxxxxxx');

配置远程访问mysql

授予root用户远程访问权限，并刷新权限（使生效）

grant all privileges on *.* to 'root' @'%' identified by 'xxxxxxxx';
flush privileges;

修改字符集

vim /etc/my.cnf
修改 /etc/my.cnf，在 [mysqld] 下添加以下语句

character-set-server=utf8
init_connect='set names utf8'

重启mysql

systemctl restart mysqld