Gossamer Forum
Home : Products : Others : MySQLMan :

Create new user in mysql

Quote Reply
Create new user in mysql
  Hi all,

I have installed mysqlman it works very well. Now my problem is create 4 user, but it's my first time I work with mysql and I don't know how create new user in mysql. My target is user log-in and can create db see only his db and table and no other users db and table.
I run win2000 server without apache server.

Regards

D

Quote Reply
Re: [delfo2000] Create new user in mysql In reply to
As mentioned before, MYSQLMAN will not allow you to add user accounts to access your MYSQL server.

Refer to http://www.mysql.com for more information on adding users.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [delfo2000] Create new user in mysql In reply to
You would need to login to mysql as the root user and do something like:

CREATE DATABASE DATABASE_NAME;

Then....

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON DATABASE_NAME.* TO USERNAME@localhost IDENTIFIED BY 'PASSWORD';

You can pick and choose which of the privileges you want.

Hope that helps.

Last edited by:

RedRum: Oct 15, 2001, 7:22 PM