grant problem

[Guillermo Cuadra]

hi list, my name is guillermo and im newbie in the list,

i have a problem and i not understand why:
the problem is the next:

//primer usuario  con privilegios de select en la base de datos adarowebsite
en la tabla propiedades
mysql> grant select on adarowebsite.propiedades to 'usuario'@'%' identified
by '12345';
Query OK, 0 rows affected (0.00 sec)

//segundo usuario  con privilegios de select en la base de datos berp en la
tabla modulo
mysql> grant select on berp.modulo to 'central'@'%' identified by '12345';
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for usuario;
+--------------------------------------------------------------------------------------------------------+
| Grants for
usuario@%
|
+--------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'usuario'@'%' IDENTIFIED BY PASSWORD
'*00A51F3F48415C7D4E8908980D443C29C69B60C9' |
| GRANT SELECT ON `adarowebsite`.`propiedades` TO
'usuario'@'%'                                          |
+--------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show grants for central;
+--------------------------------------------------------------------------------------------------------+
| Grants for
central@%
|
+--------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'central'@'%' IDENTIFIED BY PASSWORD
'*00A51F3F48415C7D4E8908980D443C29C69B60C9' |
+--------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

why dont create a user central whit same privileges as the user usuario??
im root,

thanks for your help


-- 
Solo compartiendo el conocimiento podremos alcanzar la inmortalidad.