CentOS8への移行(3)

MySQLインストール

sudo dnf install mysql-server
sudo systemctl start mysqld.service
sudo systemctl enable mysqld.service
sudo mysql_secure_installation

権限の設定

CREATE DATABASE wordpress_dnx2d;
use mysql;
insert into user (host,User,authentication_string,ssl_cipher,x509_issuer,x509_subject) values ('localhost','wordpress_user','','','','');
ALTER USER 'wordpress_user'@'localhost' IDENTIFIED BY '*************';

insert into db (host,db,user) values ('localhost','wordpress_dnx2d','wordpress_user');
update db set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',Execute_priv='Y',Event_priv='Y',Trigger_priv='Y' where db='wordpress_dnx2d';
flush privileges;