There's all of it. The gist is that only 2 users are listed.
mysql> select * from user;
+--------------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+--------------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | 77f55a9e14442c8f | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y |
| rotor.byerlyelectric.com | root | 77f55a9e14442c8f | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y |
+--------------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.00 sec)
mysql> select * from db;
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| % | test | | Y | Y | Y | Y
| Y | Y | N | Y | Y
| Y |
| % | test\_% | | Y | Y | Y | Y
| Y | Y | N | Y | Y
| Y |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.02 sec)
mysql> select * from host;
Empty set (0.00 sec)
mysql>
Liberty Young wrote:
> what does select * from user;
> select * from db;
> select * from host;
> show?
>
>
> On Fri, 2003-02-07 at 11:27, mazdaracer wrote:
>
>>I thought I had things figured out from the last msg from George. But
>>when I got back on this morning, I see I can get into the mysql DB
>>without a password as a regular user (me, pete). Also, in webmin, I can
>>easily see everything too. The password for the DB is different from my
>>regular root password, but still no prompting. Here's the output from
>>this morning:
>>
>>[pete@rotor pete]$ mysqlshow
>>+-----------+
>>| Databases |
>>+-----------+
>>| Phoenix |
>>| mysql |
>>| test |
>>+-----------+
>>[pete@rotor pete]$ mysql
>>Welcome to the MySQL monitor. Commands end with ; or \g.
>>Your MySQL connection id is 22 to server version: 3.23.55
>>
>>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>>mysql> use Phoenix
>>Database changed
>>mysql> show tables;
>>Empty set (0.00 sec)
>>
>>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> show tables;
>>+-----------------+
>>| Tables_in_mysql |
>>+-----------------+
>>| columns_priv |
>>| db |
>>| func |
>>| host |
>>| tables_priv |
>>| user |
>>+-----------------+
>>6 rows in set (0.00 sec)
>>
>>mysql> select User,Host,Password from user;
>>+------+--------------------------+------------------+
>>| User | Host | Password |
>>+------+--------------------------+------------------+
>>| root | localhost | 77f55a9e14442c8f |
>>| root | rotor.byerlyelectric.com | 77f55a9e14442c8f |
>>+------+--------------------------+------------------+
>>2 rows in set (0.01 sec)
>>
>>mysql>
>>
>>
>>With only root in the DB I would think I'd be prompted each and every time.
>>
>>pete
>>
>>---------------------------------------------------
>>PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>>To subscribe, unsubscribe, or to change you mail settings:
>>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
(text/plain)