grep'temporary password' /var/log/mysqld.log
(密码为by后面的)
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'SHIlp123...';
6.添加登陆用户
GRANT ALL PRIVILEGES ON *.* TO 'new1'@'%' IDENTIFIED BY '密码(满足密码强度要求)' WITH GRANT OPTION;
7.配置默认编码utf8
vim /etc/my.cnf
在[mysqld]下
character_set_server=utf8
init_connect='SET NAMES utf8'
systemctl restart mysqld.server
8.为wordpress创建一个普通用户和数据库
CREATE DATABASE wp DEFAULT CHARSET utf8;--创建数据库wp
CREATE USER 'wp'@'localhost' IDENTIFIED BY 'Dcba.1234';--创建一个新用户wp.密码为Dcba.4321
GRANT ALL ON wp.* TO 'wp'@'localhost';--将数据库wp的所有访问权限授予给用户wp
PRIVILEGES FLUSH;