more MySQL issues

[mazdaracer]

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
>