Hi,
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 ?
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)
But without password it works...
Do you know how to solve that problem ? (I already try to make a SET
PASSWORD FOR web ... but
it didn't change anything)
Best regards
Nicolas Beaumont
Atos Origin - System Integration
Tour Les Miroirs
18 Av. d'Alsace
92926 Paris La Défense Cedex
France
Phone : +33(0) 1 70 92 40 33
e-mail : [EMAIL PROTECTED]
Website : www.atosorigin.com
---------------------------------------------------------------------
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
