List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:May 8 2007 12:23pm
Subject:Re: how to create new username n password in mysql
View as plain text  
GRANT CREATE,INSERT,DELETE,UPDATE,SELECT PRIVILEGES ON pauldb.*
TO poul@localhost 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
> paul@localhost;
> 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/mysql?unsub=1
>
>
> --
> 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.

Thread
how to create new username n password in mysqlsunisundar8 May
  • Re: how to create new username n password in mysqlMogens Melander8 May
    • Re: how to create new username n password in mysqlsunisundar8 May
      • Re: how to create new username n password in mysqlMogens Melander8 May