服务器本地查看数据库用户(happy@localhost)的权限:
[root@localhost ~]# mysql -u"root" -p"888" -e "show grants for happy@localhost;"
+--------------------------------------------------------------------------------------------------------------+
| Grants for happy@localhost |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'happy'@'localhost' IDENTIFIED BY PASSWORD '*398D8BD83BF246533D81FF0E614402C6505D0EED' |
| GRANT ALL PRIVILEGES ON `wordpress`.* TO 'happy'@'localhost' |
+--------------------------------------------------------------------------------------------------------------+
注释:数据库用户(happy@localhost)只对库wordpress有完全控制的权限。
########
########
查看虚拟主机(站点)列表: