时间:2021-07-01 10:21:17 帮助过:278人阅读
step1:
登陆
- xinjin@xjPC:~$ mysql -u root -p
- Enter 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 changed
- mysql> 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的所有用户