Sami Maisniemi <[EMAIL PROTECTED]> writes:
>> mysql> use mysql
>> mysql> select User,Host,Password,Select_priv from user;
>>
>> which will show basic access capabilities for user/host/password
>
>Hmmm ... did not work as you can see:
>
>mysql> select User,Host,Password,Select_priv from user;
>ERROR 1054: Unknown column 'User' in 'field list'
Hmmmm, that's interesting. You'll probably need to take a look
at the 'desc user;' output. Mine reports the following initial
portion:
mysql> desc user
-> ;
+-----------------------+-----------------------------------+------+-----+-----
----+-------+
| Field | Type | Null | Key |
Default | Extra |
+-----------------------+-----------------------------------+------+-----+-----
----+-------+
| Host | varchar(60) binary | | PRI |
| |
| User | varchar(16) binary | | PRI |
| |
| Password | varchar(16) binary | | |
| |
| Select_priv | enum('N','Y') | | | N
| |
...
If yours does not report Host and User as the first two columns, your user
table has been corrupted in some manner. You haven't tried to define your
own user table have you? If so, that may be what is causing the errors.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
