怎么查看mysql主机名称

查看mysql主机名称的示例：

通过sql语句“ select host,user,password from mysql.user;”可以查看主机、用户和密码信息。例：

mysql>selecthost,user,passwordfrommysql.user;
+-----------+---------+-------------------------------------------+
|host|user|password|
+-----------+---------+-------------------------------------------+
|localhost|root|*23AE809DDACAF96AF0FD78ED04B6A265E05AA257|
|localhost|afdwe|*E6CC90B878B948C35E92B003C792C46C58C4AF40|
|localhost|dfsd|*E6CC90B878B948C35E92B003C792C46C58C4AF40|
|%|sdfsdf|*00A51F3F48415C7D4E8908980D443C29C69B60C9|
|%|aaadfe|*13F9536FF36FEA8F67E07DC30BC06D86AE67CB75|
|%|adfe|*00A51F3F48415C7D4E8908980D443C29C69B60C9|
+-----------+---------+-------------------------------------------+
6rowsinset(0.06sec)

上一篇：mysql和mysqli的区别是什么

下一篇：wordpress如何搭建站群