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:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 1:03 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Users of RDBMS On Wed, 8 Sep 2004 12:01:55 -0700 (PDT), Pahlevanzadeh Mohsen <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
