Of course. That was it ;-)
I completely forgot about that for a moment. I looked in the wrong place, oooh no... Thanks a lot, (such a shame I didnt realize first)... Best regards Nils Valentin Tokyo/Japan On Thursday 06 November 2003 23:23, gerald_clark wrote: > 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) -- Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ ------------------------------------------------------- -- Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
