说明:mysql8 发布有一段时间了,但实际用起来还是有些问题,尤其在线上是不能出任何问题的。所以推荐 mysql 5.7
下载安装 mysql5.7 最新 yum 源
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
yum 查看并安装 mysql
yum repolist enabled | grep mysql.*
yum -y install mysql-community-server
启动服务
systemctl restart mysqld.service
查看默认密码,并记录此密码(qtHbU3YeKl!p)
grep "password" /var/log/mysqld.log
登录 mysql,输入root默认密码,登录进去后,
mysql -uroot -p
修改root默认密码(必须包含数字,大小写字母,特殊符号才能成功)
alter user 'root'@'localhost' identified by 'lI1!oO0!10i';
flush privileges;
查看编码
show variables like 'character%';
修改编码(vim /etc/my.cnf),建议使用 utf8mb4
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
[mysql]
default-character-set=utf8mb4
[client]
default-character-set=utf8mb4
[mysql.server]
default-character-set=utf8mb4
[mysqld_safe]
default-character-set=utf8mb4
允许外网连接
# database 替换成 数据库
# username 替换成 登录帐号
# password 替换成 登录密码
GRANT ALL PRIVILEGES ON database.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;