RE: [PHP] Users of RDBMS
| From: | Mulley, Nikhil | Date: | Thu, 09 Sep 2004 21:37:35 +0000 |
| Subject: | RE: [PHP] Users of RDBMS | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-196266@lists.php.net to get a copy of this message | ||
You can create user from mysql prompt by connecting it through first
cmd>mysql -h host -u userid -p instance
password : ******
then type
GRANT ALL PRIVILGES ON *.* TO 'newuser'@'host'
IDENTIFIED BY 'password' with GRANT OPTION;
where newuser is new users id and host may be either localhost or any other host,if you want to add
that user to connect from any host then replace 'host' with '%'
with single quotes.
and password is new users password.
Regards
Nikhil
-----Original Message-----
From: Victor Saldaña D. [mailto:vsaldana@gmail.com]
Sent: Thursday, September 09, 2004 1:03 AM
To: php-general@lists.php.net
Subject: Re: [PHP] Users of RDBMS
On Wed, 8 Sep 2004 12:01:55 -0700 (PDT), Pahlevanzadeh Mohsen
<m_pahlevanzadeh@yahoo.com> wrote:
> Dears,
> I need to create user for MySQL.
> Please guide me......
Please RTFM
http://dev.mysql.com/doc/mysql/en/Adding_users.html
--
Victor Saldaña D.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php