Linux（CentOS6）yum安装MySQL

Linux（CentOS6）yum安装MySQL

---

注意：用此方法安装的MySQL版本为5

修改下载源链接格式

修改下载源链接为阿里
重新初始化yum（重建cache）

sed -i "s|enabled=1|enabled=0|g" /etc/yum/pluginconf.d/fastestmirror.conf
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
curl -o /etc/yum.repos.d/CentOS-Base.repo https://www.xmpan.com/Centos-6-Vault-Aliyun.repo 
yum clean all
yum makecache

安装MySQL

yum install mysql-server
service mysqld start
chkconfig --level 345 mysqld on

设置MySQL服务开机自启chkconfig --level 345 mysqld on

设置mysql默认编码格式

修改mysql的配置文件，设置默认编码格式为utf8

vi /etc/my.cnf

按a或insert进入编辑

[mysql]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

按ESC退出编辑
输入:wq保存退出

重启mysql服务

service mysqld restart

进入mysql验证修改情况

mysql
show variables like 'character%';

设置远程连接

以本机ip为192.168.64.1为例

mysql
use mysql;
CREATE USER 'root'@'192.168.64.1' IDENTIFIED BY '123456';

若MySQL版本为8+需要输入（MySQL5不需要）
ALTER USER 'root'@'192.168.64.1' IDENTIFIED WITH mysql_native_password BY '123456';

grant all privileges  on *.* to root@'192.168.64.1';
flush privileges;

至此，Navicat就可以远程连接到Linux的MySQL了

---

以上就是本期总结的全部内容，愿大家相互学习，共同进步！