|
用户'root'@'???'只要@前面的是"root",
<question1>那么该用户就是高权限root?</question1>
================
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> describe userl
-> ;
ERROR 1146 (42S02): Table 'mysql.userl' doesn't exist
mysql> describe user;
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
............
37 rows in set (0.00 sec)
mysql> select user,host from user;
+--------+-----------------------+
| user | host |
+--------+-----------------------+
| | localhost |
| shell | localhost |
| root | localhost |
| | localhost.localdomain |
| root | localhost.localdomain |
+--------+-----------------------+
5 rows in set (0.02 sec)
mysql>
=====
有两个root,要是以后为了方便,还会有更多的root,<question2>但是他们的密码?不是有问题吗?</question2>矛盾.....ing.... |
|