Mysql下查看用户、数据库的例子

在mysql中要查看用户名与数据库我们可以在mysql命令模式下直接使用相关的命令就可以查了,具体的小编就为各位介绍一下吧.

命令行下查看用户、数据库:

1. mysql>usegbk#进入gbk数据库
2. Databasechanged
3. mysql>showtables;#查看gbk数据库的所有表
4. Emptyset(0.00sec)
5. mysql>useultrax;
6. Readingtableinformationforcompletionoftableandcolumnnames
7. Youcanturnoffthisfeaturetogetaquickerstartupwith-A
8. Databasechanged
9. mysql>showtables;
10. mysql>showtablesfromultrax;#查看ultrax数据库的数据表[mysql>showtablesinultrax;]
11. +-----------------------------------+
12. |Tables_in_ultrax|
13. +-----------------------------------+
14. |pre_common_admincp_cmenu|
15. |pre_common_admincp_group|
16. …………………………………省略部分内容………………………………
17. |pre_ucenter_tags|
18. |pre_ucenter_vars|
19. +-----------------------------------+
20. 293rowsinset(0.01sec)
21. mysql>usegbk
22. Databasechanged
23. mysql>selectdatabase();
24. +------------+
25. |database()|
26. +------------+
27. |gbk|
28. +------------+
29. 1rowinset(0.00sec)
30. mysql>selectuser,hostfrommysql.user;#查看用户、主机
31. +------+-----------+
32. |user|host|
33. +------+-----------+
34. |root|127.0.0.1|
35. |root|::1|
36. ||lamp|
37. |root|lamp|
38. ||localhost|
39. |root|localhost|
40. +------+-----------+
41. 6rowsinset(0.06sec)
42. mysql>dropuser''@'localhost';#删除用户名为空，主机名为localhost
43. mysql>dropuser''@'lamp';#删除主机名为lamp，用户名为空
44. QueryOK,0rowsaffected(0.09sec)
45. mysql>selectuser,hostfrommysql.user;#查看是否删除成功
46. +------+-----------+--phpfensi.com
47. |user|host|
48. +------+-----------+
49. |root|127.0.0.1|
50. |root|::1|
51. ||lamp|
52. |root|lamp|
53. |root|localhost|
54. +------+-----------+
55. 5rowsinset(0.00sec)

mysql> delete from mysql.user where user='' and host='lamp';#如果无法删除的可以采用类似此种的方法进行删除.

mysql> flush privileges;