step1:
登陆xinjin@xjPC:~$ mysql -u root -pEnter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.17-0ubuntu0.16.04.1 (Ubuntu)
Copyright (c) 2000, 2016, 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.
step2:
进入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 changedmysql> select host,user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| localhost | TestUser |
| localhost | debian-sys-maint |
| localhost | myTestUser |
| localhost | mysql.sys |
| localhost | phpmyadmin |
| localhost | root |
+-----------+------------------+
6 rows in set (0.00 sec)
step3:
退出mysql> exit
Bye
xinjin@xjPC:~$
______________________________________________________________________________________________________
若是您觉得此博文有可以改进的地方或者内容过时了,请评论,我会仔细思考的。
注:此博文仅用于科研学习,如果侵犯到您的权益,请及时告知,我会做出相应的处理。
本文出自 “心静如水,志刚如磐.” 博客,请务必保留此出处http://xinjingzhigang.blog.51cto.com/12262830/1905525
mysql5.7基础 查看mysql的所有用户
标签:mysql5.7基础 查看mysql的所有用户
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://xinjingzhigang.blog.51cto.com/12262830/1905525