mysql

create database wordpress;

CREATE USER 'user'@'localhost' IDENTIFIED BY '123456';

GRANT ALL PRIVILEGES ON wordpress.* TO 'user'@'localhost' IDENTIFIED BY '123456';

FLUSH PRIVILEGES;

\\q

mysql

ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD('your_pasword');

\\q

rm -rf /usr/share/nginx/html/index.php

cd /usr/share/nginx/html
wget https://cn.wordpress.org/wordpress-5.0.4-zh_CN.tar.gz
tar zxvf wordpress-5.0.4-zh_CN.tar.gz

cd /usr/share/nginx/html/wordpress
cp wp-config-sample.php wp-config.php

vim wp-config.php

 // ** MySQL settings - You can get this info from your web host ** //
 /** The name of the database for WordPress */
 define('DB_NAME', 'wordpress');

 /** MySQL database username */
 define('DB_USER', 'user');

 /** MySQL database password */
 define('DB_PASSWORD', '123456');

 /** MySQL hostname */
 define('DB_HOST', 'localhost');

http://your_CVM_public_IP/wordpress