1. 准备工作
CentOS 7 的 yum 源中默认是没有 MySQL 的,需要先将 MySQL 加入我们的 CentOS yum 源中。
首先下载 MySQL 的 repo 源:
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
将mysql 加入 yum 源:
yum localinstall mysql57-community-release-el7-8.noarch.rpm
查看 mysql 源:
yum repolist enabled | grep "mysql.*-community.*"
2. 安装
安装命令:
yum install mysql-community-server
安装过程根据网络情况,等待安装完成:
设置编码为utf8mb4:
vim /etc/my.cnf
需要手动添加上[client]和[mysql]以及补充[mysqld]:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
修改启动端口:
[client]
port = 3323
[mysqld]
port = 3323
启动服务:
systemctl start mysqld
systemctl status mysqld
设置开机启动:
systemctl enable mysqld
systemctl daemon-reload
查看root默认密码,然后登录mysql进行修改:
grep 'temporary password' /var/log/mysqld.log
3. 登录Mysql
登录命令:
mysql -uroot -ppassword -Pport
修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '你要改的密码';
注意下密码安全策略:
SHOW VARIABLES LIKE 'validate_password%';
修改安全策略(生产环境不建议如此操作):
# 设置密码的验证强度等级
set global validate_password_policy=LOW;
# 设置为 6 位的密码
set global validate_password_length=6;
设置远程登录用户(admin):
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;