> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> 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
