no getting an error now like " check the manual that corresponds to your mysql version....." mine is mysql 5 version
Mogens Melander wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/how-to-create-new-username-n-password-in-mysql-tf3709178.html#a10375368 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]