I am using the command line for grant operations, no flushing though Why are you using 4.0,6? any special reason? I am using a custom (i compiled myself) 4.0.16
Here is an example operation: ******************** TRY TO LOG WITHOUT PASS, ERROR [EMAIL PROTECTED] vmedina]$ mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) ******************* TRY TO LOG WITH PASSWORD, SUCCESS! [EMAIL PROTECTED] vmedina]$ mysql -u vmedina -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ************** CREATE A USER, NO FLUSH, LOGOUT mysql> grant all privileges on *.* to test@'%' identified by '1234' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye ************ LOG INTO MYSQL USING THE NEW USER, ************ PROVIDE PASS, SUCCESS [EMAIL PROTECTED] vmedina]$ mysql -u test -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> *********** USE THE NEW USER TO CREATE *********** A YET AGAIN A NEW USER, NO FLUSH [EMAIL PROTECTED] vmedina]$ mysql -u test -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all privileges on *.* to test03@"%" identified by '1234' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> I've never used flush. I must say that the only user in that machine is a user called vmedina, that's me, 'cause it is my development workstation, as i told you i deleted ALL users after i created the vmedina user, simply because there is no need for others, vmedina user can handle all admin operations in a MySQL server, and create other users as needed. If you need anything else just let me know my friend :) Best Regards -- ...................................................................... * _ _ ______ _____ _ .. * \ \ \ | ____| __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * > > > | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | |____| | / ____ \|_| || www.superferreteria.com.ve * /_/_/ |______|_| /_/ \_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice ...................................................................... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
