systemctl start mariadb
mysql -u root -p
select User, host from mysql.user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'toor' WITH GRANT OPTION;
FLUSH PRIVILEGES;
mysql -u root -p
# 创建一个专给 WordPress 存数据的数据库
create database f8x_info; # 最后的"f8x_info"为数据库名
# 创建用于 WordPress 对应用户
create user f8x@localhost identified by 'password'; # "f8x"对应创建的用户,"password"内填写用户的密码
# 分别配置本地登录和远程登录权限
grant all privileges on f8x_info.* to f8x@'localhost' identified by 'password';
grant all privileges on f8x_info.* to f8x@'%' identified by 'password';
flush privileges; # 刷新权限
exit;
安装 phpmyadmin
yum install phpmyadmin
vim /etc/httpd/conf.d/phpMyAdmin.conf
-- Require ip 127.0.0.1
-- Require ip ::1
++ Require all granted
-- Require ip 127.0.0.1
-- Require ip ::1
++ Require all granted
```bash
systemctl restart httpd