Hi Nils, as said Clark, looks at db table. In fact the account xoops will have full access to database 'xoops' only.
Regards ----- Original Message ----- From: "gerald_clark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 06, 2003 2:23 PM Subject: Re: Setting up user acounts in 4.0.16 > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]