五、nginx搭建WordPress博客系统
mysql> create database wp_db;mysql> grant allon wp_db.* to wpadmin@localhost identified by 'wp123456';
mysql> grant all on wp_db.* towpadmin@127.0.0.1 identified by 'wp123456';
mysql> FLUSH PRIVILEGES;
mysql> select user,host from mysql.user;
+---------+-----------+
| user | host |
+---------+-----------+
| root | 127.0.0.1 |
| wpadmin | 127.0.0.1 |
| root | localhost |
| wpadmin | localhost |
+---------+-----------+
4 rows in set (0.00 sec)
mysql> show grants forwpadmin@127.0.0.1;
+----------------------------------------------------------------------------------------------------------------+
| Grants for wpadmin@127.0.0.1 |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO'wpadmin'@'127.0.0.1' IDENTIFIED BY PASSWORD'*126BB20052A4CCAAE93527CE311D3FC8B6A7D08D' |
| GRANT ALL PRIVILEGES ON `wp_db`.* TO'wpadmin'@'127.0.0.1' |
+----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> quit
Bye
页:
[1]