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]