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了
以上就是本期总结的全部内容,愿大家相互学习,共同进步!