How to create a MySQL user account?

[Anon]

Hi There,

I have MySQL and PHP installed on a Red Hat machine and up until now I've been able to access the dbase with the root/pwd. However I have a couple clients who want access to the MySQL database. How can I create a database "monkey" for them and create a user/pwd for just that database. They would need pretty much all the permissions (insert,drop,alter, etc).

Any help would be appreciated.

Thanks,

-dr

[toma42]

use the db and user tables in the mysql database. Read the manual for instructions.

[tsmith]

First you have to make a user:
login to mysql as root; use mysql;
insert into users (user, host, select_priv, insert_priv, update_priv, delete_priv) values ('monkey', 'localhost', 'Y', 'Y', 'Y', 'Y');

I'd recommend only gving them select, insert, update and delete.

Change mysql user password at shell like so:
[tsmith]$ mysqladmin -u monkey password newPass
this connects to mysqld as web with password of the existing pass (nothing),
then changes it to 'newPass'. Or you can do it from mysql directly in the user
table, but then you have to restart the server which is a pain.
There is probably more to it, but this will get you started.