安装Wordpress遇到database连接问题，解决

mysql [-u] [username] [-p] 登陆命令，username表示用户名，-p表示以密码方式登陆（输入密码不显示****）

实例：

mysql -u xiaowei -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 56
Server version: 5.7.40-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

主要命令： CREATE USER 'username'@'localhost' INDENTFIED BY 'PASSWORD';

其中username是用户名，localhost是ip地址，如果是数据库在本地不变,PASSWORD是密码。

实例： (->表示回车)

mysql> CREATE USER 'james'@'localhost'
    ->     IDENTIFIED BY 'tiger';
Query OK, 0 rows affected (0.01 sec)

SHOW DATABASS;是列出数据库表

实例：

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| wordpress          |
+--------------------+

use  <数据库表>;表示选中数据库表

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

赋予权限命令

GRANT ALL ON 数据库表.行 TO 'username'@'localhost'  (注意不要忘记数据库表后的.)

mysql>GRANT ALL ON mysql.* TO 'xiaowei'@'localhost';

查看表的用户名有哪些 select user frome user;

mysql>select user from user;
+------------------+
| user             |
+------------------+
| debian-sys-maint |
| mysql.session    |
| mysql.sys        |
| root             |
| xiaowei          |
+------------------+
5 rows in set (0.00 sec)

完成之后，不要在网页中输入ip地址安装，还需要把信息填入 wp-config-sample.php中

/** The name of the database for WordPress */
define( 'DB_NAME', 'database_name_here' );

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

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

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

/** Database Charset to use in creating database tables. */
define( 'DB_CHARSET', 'utf8' );

修改database_name_here(数据库表)、username_here(用户名)、password_here(密码)、localhost(ip地址)

重命名命令：

#mv /var/www/html/wp-config-sample.php /var/www/html/wp-config.php