Hi,
I'm trying to uderstand the difference between these tables (mysql.user, mysql.db)
v.4.0.
I want user "usera" from "hostname1" to connect to "hostname2" which is where the
Mysql db is running and have only select priv on db "db_1".
"Hostname1" has mysql clients on it.
Host:
mysql> select * from user where Host = 'hostname1';
+-------------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| 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 | ssl_type | ssl_cipher | x509_issuer |
x509_subject | max_questions | max_updates | max_connections |
+-------------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| hostname1 | usera | 01111111116 | N | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N | N |
N | N | N | N | N
| ANY | | | | 0 |
0 | 0 |
+-------------------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
1 row in set (0.00 sec)
mysql>
db:
mysql> select * from db where Host = ' hostname1';
+-------------------+--------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv |
Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
+-------------------+--------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| hostname1 | db_1 | usera | Y | N | N | N | N
| N | N | N | N | N | N
| N |
+-------------------+--------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
1 row in set (0.00 sec)
mysql>
Which table gives user "usera" from "hostname1" permission to just do select
statements on the table db_1 on "hostname2"?
I think its db?
But since user says 'N' for all options for this user from "hostname1" does that
override the db table options??
I'v looked at the manual, but I'm just not getting it... Can someone break it down for
me...
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
