Nicolas BEAUMONT writes:
> I have problem to manage the users of my MySQL server. > I connect to the database mysql as superuser and I try to create a new user > on another database called PVE. I use : > GRANT ALL PRIVILEGES ON PVE.* TO web@'%' IDENTIFIED BY 'PVEweb' WITH GRANT > OPTION; > > The answer is : Query OK, 0 rows affected (0.00 sec) > My first question is, is it normal to see 0 rows affected ? Yes. > When I try to connect to the database as web, I can't use my password. > [root@lipve php]# mysql -u web -p > Enter password: > ERROR 1045: Access denied for user: 'web@localhost' (Using password: YES) localhost is a special value not matched by wildcards. You need a separate row in the user table for web@localhost. It might also be wise not to allow access from every computer in the world, unless you have good reason to do so. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
