You set db privileges, and then looked at the user table. Check the db table.
If you want to set global privileges you need to specify *.* not xoops.*.
Nils Valentin wrote:
Hi Thierno,
Please see below what I get. I would expect the privileges to be set to Y.
------------------------------------------------
GRANT ALL PRIVILEGES ON xoops.* TO xoops@"%" identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec)
mysql> select * from user where User="xoops"\G *************************** 1. row *************************** Host: % User: xoops Password: 5a62d73531da5605 Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 1 row in set (0.00 sec)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]