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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
