查看数据库用户root@localhost的权限:
mysql> show grants for root@localhost;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*41DDB5DFD213B288EE050BD64DC6AA36815A3486' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
注释:数据库用户root@localhost的权限可以管理所有数据库。
查看所有的库:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| discuz2 |
| discuz3 |
| mysql |
| performance_schema |
+--------------------+
5 rows in set (0.08 sec)
登录phpMyAdmin:
http://192.168.168.130/phpmyadmin/