GRANT CREATE,INSERT,DELETE,UPDATE,SELECT PRIVILEGES ON pauldb.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mysecretpassword';
On Tue, May 8, 2007 13:57, sunisundar wrote: > > how to create new username n password in mysql using commands. > > followed these steps:: > mysql> create database pauldb; > Query OK, 1 row affected (0.00 sec) > > # > # Now we create the user paul and give him full > # permissions on the new database > mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to > [EMAIL PROTECTED]; > Query OK, 0 rows affected (0.00 sec) > > # > # Next we set a password for this new user > # > mysql> set password for paul = password('mysecretpassword'); > Query OK, 0 rows affected (0.00 sec) > > # > # Cleanup and ext > mysql> flush privileges; > mysql> exit; > > > > when next time i login using this pwd not working..... > Give me proper commands. > -- > View this message in context: > http://www.nabble.com/how-to-create-new-username-n-password-in-mysql-tf3709178.html#a10374454 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]