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/
On Thursday 06 November 2003 23:00, Thierno Cissé wrote:
> Hi Nils,
> what want you to say by : It doesnt write the privileges (on my machine).
> It is because you succeed reaching all the database objects or what ?
> Give some more details.
>
> Regards.
> Thierno6C.
>
> ----- Original Message -----
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, November 07, 2003 1:16 PM
> Subject: Fwd: Re: Setting up user acounts in 4.0.16
>
>
>
> >
> >
> > Hi Thierno,
> >
> > you are right that the synatx I gave you is not correct. Thank you for
> > pointing this out. I made the mistake when typing the e-mail ;-)
> >
> > However the original problem stays. It doesnt write the privileges (on
> > my
machine).
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan
> >
> > On Thursday 06 November 2003 17:42, you wrote:
> >
> > > Hi Nils,
> > > your instruction of account creation don't agree with the syntax .
> > > To create an account do this :
> > >
> > > GRANT ALL PRIVILEGES ON xoops.* TO xoops@"%" identified by 'xxxx';
> > > The percent character '%' is enclosed by double-quote.
> > >
> > > Regards
> > >
> > > Thierno6C - MySQL 4.0.15.
> > >
> > > ----- Original Message -----
> > > From: "Nils Valentin" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Friday, November 07, 2003 8:00 AM
> > > Subject: Setting up user acounts in 4.0.16
> > >
> > >
> > > > Hi Mysql fans ;-),
> > > >
> > > > today I had a funny experience and I wanted to double check that.
> > > > When I am trying to create a user account in the 4.0.16 -max version
> > >
> > >
> > > (tar.gz
> > >
> > >
> > > > format from www.mysql.com) then it would create the user account put
>
> not
>
> > >
> > > set
> > >
> > >
> > > > the privileges. The privileges would still stay at N.
> > > >
> > > > Here is the command I tried:
> > > >
> > > > grant all on xoops.* to 'xoops_root'@'%' identified by 'xxxx';
> > > >
> > > >
> > > > Perhaps I have done a mistake somewhere, but I cant figure out what
>
> went
>
> > > > wrong.
> > > >
> > > > I had to manually update the fields with the update .. set command
> > > > and
>
> a
>
> > >
> > > flush
> > >
> > >
> > > > privileges.
> > > >
> > > > Can anybody copy me on that ?
> > > >
> > > > Best regards
> > > >
> > > > 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]
> >
> >
> > --
> > 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]
>
> >
>
>
>
>
--
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
