mysql查看用戶名的方法：首先進入mysql并啟動數據庫；然后連接到數據庫；最后輸入“select host,user from mysql.user;”命令查看用戶名以及信息即可。
我們在使用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
