Hi I'm new to mysql and i'm trying to understand the privileges table. With the following configuration of the user table +---------------------------+----------+ | host | user | +---------------------------+----------+ | % | robber | | 192.168.0.0/255.255.255.0 | phpuser | | 192.168.0.0/255.255.255.0 | root | | localhost | root | +---------------------------+----------+ and of the tables_priv +---------------------------+-------------+----------+-------------+ | host | db | user | table_name | +---------------------------+-------------+----------+-------------+ | 192.168.0.0/255.255.255.0 | esempio | phpuser | utenti | | localhost | esempio | phpuser | utenti | | port1 | mysql | phpadmin | db | | port1 | mysql | phpadmin | tables_priv | | port1 | mysql | phpadmin | user | +---------------------------+-------------+----------+-------------+
the phpuser can connect fron the internal network but gets the following error when selects ERROR 1142: select command denied to user: 'phpuser@linux' for table 'utenti' It works only if I change to the followings assigning explicitly the name of the host: +---------------------------+-------------+----------+-------------+ | host | db | user | table_name | +---------------------------+-------------+----------+-------------+ | linux | esempio | phpuser | utenti | | localhost | esempio | phpuser | utenti | | port1 | mysql | phpadmin | db | | port1 | mysql | phpadmin | tables_priv | | port1 | mysql | phpadmin | user | +---------------------------+-------------+----------+-------------+ Why? from the manual it doesn't happen. If anyone can help me thanks in advance. -- ----------------------------------------------------------------------- Roberto Bernetti e-mail: [EMAIL PROTECTED] V. S.da Vecchia del Pinocchio 1/A 60131 ANCONA tel/fax 071 2867103 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
