systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld
登录数据库
## 查看初始密码less /var/log/mysqld.log |grep pass
## 登录数据库
mysql -uroot -p'XRY046OefV<7'
修改MySQL数据库密码策略
set global validate_password_length=4;set global validate_password_policy=0;
创建远程登录用户
ALTER USER'root'@'localhost' IDENTIFIED BY '123456';#创建一个远程登录用户
create user 'root'@'%' identified by '123456';# 配置外部访问权限
grant all privileges on *.* to root@"%" identified by '123456' with grant option;# 刷新权限
flush privileges;
设置服务器编码为utf8
vi /etc/my.cnf
## 在mysqld下面设置character_set_server=utf8
## 重启服务
systemctl restart mysqld