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