List:General Discussion« Previous MessageNext Message »
From:Pam Astor Date:April 18 2008 2:02pm
Subject:RE: Can't get a login shell for some databases
View as plain text  




> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




> would be much more easier if you would send this output here (with faked 
> names, passwords and hosts ...)

OK...here it is:

SELECT * from mysql.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 | Show_db_priv | Super_priv |
Create_tmp_table_priv | Lock_tables_priv | Execute_priv |
Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv
| Create_routine_priv | Alter_routine_priv | Create_user_priv |
ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions |
max_updates | max_connections | max_user_connections |
+-------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
|
localhost   | root    | 076d41f46bee2ec3 | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          | Y            | Y          |
Y                     | Y                | Y            |
Y               | Y                | Y                | Y             
| Y                   | Y                  | Y               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
myhost.net  | root    |                  | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          | Y            | Y          |
Y                     | Y                | Y            |
Y               | Y                | Y                | Y             
| Y                   | Y                  | Y               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
myhost.net  |         |                  | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
localhost   |         |                  | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
%           | user1   | 6827b0f45e06bf7d | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
localhost   | user1   | 6827b0f45e06bf7d | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
localhost   | user2   | 2c8a96ef355f5ff8 | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
%           | user3   | 0528e2af7e81824b | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
%           | user4   | 30e92ad80ce35e2d | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
%           | user5   | 707c712c3acb8a5c | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
%           | user6   | 780a7d431493c4b5 | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
|
%           | user7   | 5823d7d3514e94a1 | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          | N            | N          |
N                     | N                | N            |
N               | N                | N                | N             
| N                   | N                  | N               
|          |            |             |              |             0
|           0 |               0 |                    0 |
+-------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
12 rows in set (0.02 sec) 
_________________________________________________________________
More immediate than e-mail? Get instant access with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008
Thread
Can't get a login shell for some databasesPam Astor17 Apr
  • Re: Can't get a login shell for some databasesSebastian Mendel18 Apr
    • RE: Can't get a login shell for some databasesPam Astor18 Apr
      • Re: Can't get a login shell for some databasesSebastian Mendel18 Apr
        • RE: Can't get a login shell for some databasesPam Astor18 Apr
      • Re: Can't get a login shell for some databasesBen Clewett18 Apr
        • RE: Can't get a login shell for some databasesPam Astor18 Apr
          • Re: Can't get a login shell for some databasesBen Clewett18 Apr
            • RE: Can't get a login shell for some databasesPam Astor18 Apr
              • Re: Can't get a login shell for some databasesBen Clewett21 Apr
                • RE: Can't get a login shell for some databases SOLVEDPam Astor21 Apr
RE: Can't get a login shell for some databasesPam Astor18 Apr