Re: [PHP-DB] create username and password From: Leonard Tambunan (leonard <email protected>)
Date: 11/30/00

> i just downloaded MySQL and i cant figure out how to create a user name
> and password. PLEASE HELP!

use mysqladmin to set root (of mysql) password.

<root <email protected>>/path_to_mysql_bin/mysqladmin password 'your_password'

To create another mysql user, use SQL command GRANT.
example:

mysql> GRANT insert,select ON database.* TO newusername <email protected>
        IDENTIFIED BY 'newuser_password'; 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>