List:General Discussion« Previous MessageNext Message »
From:sunisundar Date:May 8 2007 12:58pm
Subject:Re: how to create new username n password in mysql
View as plain text  
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 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.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
> 

-- 
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.

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