Re: create username and password
| From: | Leonard Tambunan | Date: | Thu, 30 Nov 2000 09:06:26 +0000 |
| Subject: | Re: create username and password | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4876@lists.php.net to get a copy of this message | ||
> 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@machine>/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@localhost
IDENTIFIED BY 'newuser_password';