Shulou(Shulou.com)06/01 Report--

This post is about how mysql looks at usernames. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

Start database:

[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 Connect to database:

[root@server ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

View database list:

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

View user status:

mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> 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> Thank you for reading! About mysql how to view the user name to share here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.