mysql怎么查看用戶名?

mysql查看用戶名的方法:首先進入mysql并啟動數據庫;然后連接到數據庫;最后輸入“select host,user from mysql.user;”命令查看用戶名以及信息即可。

mysql怎么查看用戶名?

我們在使用mysql的時候,有時候需要來查看當前用戶。本篇文章將和大家講述mysql怎么查看用戶名,感興趣的朋友可以了解一下。

啟動數據庫:

[root@server?~]#?mysqld_safe?&[1]?3289 [root@server?~]#?130913?08:19:58?mysqld_safe?Logging?to?'/usr/local/mysql/data/server.gao.err'. 130913?08:19:58?mysqld_safe?Starting?mysqld?daemon?with?databases?from?/usr/local/mysql/data

連接到數據庫:

[root@server?~]#?mysql?-uroot?-p Enter?password:? Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?g. Your?MySQL?connection?id?is?1 Server?version:?5.6.13?MySQL?Community?Server?(GPL)  Copyright?(c)?2000,?2013,?Oracle?and/or?its?affiliates.?All?rights?reserved.  Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its affiliates.?Other?names?may?be?trademarks?of?their?respective owners.  Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement.  mysql>

查看數據庫列表:

mysql>?show?databases; +--------------------+ |?Database???????????| +--------------------+ |?information_schema?| |?mysql??????????????| |?performance_schema?| |?test???????????????| +--------------------+ rows?in?set?(0.00?sec)  mysql>

?查看用戶狀態:

mysql>?use?mysql; Reading?table?information?for?completion?of?table?and?column?names You?can?turn?off?this?feature?to?get?a?quicker?startup?with?-A  Database?changed mysql>?select?host,user?from?mysql.user; +------------+------+ |?host???????|?user?| +------------+------+ |?127.0.0.1??|?root?| |?::1????????|?root?| |?localhost??|??????| |?localhost??|?root?| |?server.gao?|??????| |?server.gao?|?root?| +------------+------+ rows?in?set?(0.00?sec)  mysql>

? 版權聲明
THE END
喜歡就支持一下吧
點贊9 分享