MySQL: Create user with rights only for specific db [duplicate]

Question

I would need to create MySQL user programatically with the privileges only for specific db. Say there are databases a,b,c and I would need to create user who has rights only for B. I am sure its possible but my googling was not successful. Thank you!

Björn · Accepted Answer · 2009-11-02 07:28:58Z

24

grant all
    on B.*
to
    'user'@localhost
identified by
    'password'

The user 'user' with password 'password' now have access to all tables in the database 'B'. (Of course you need to run this query with a high priv user)

answered Nov 2, 2009 at 7:28

Björn

29.4k9 gold badges67 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MarkR Over a year ago

You could also change "ALL" to a more reasonable set of privileges if it is going to be used by an application. Most web apps do not need to create,alter,drop tables.

Ricain Over a year ago

grant all on B.* to 'user'@localhost identified by 'password'; to copy and paste faster ;)

RRUZ · Accepted Answer · 2009-11-02 07:30:10Z

22

you can try this

 CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'some_pass';
 grant all privileges on B.* to 'myuser'@'localhost' identified by 'some_pass';

answered Nov 2, 2009 at 7:30

RRUZ

137k20 gold badges365 silver badges489 bronze badges

1 Comment

MTVS Over a year ago

Just by granting privileges to an user if it doesn’t exist it is created.

Collectives™ on Stack Overflow

MySQL: Create user with rights only for specific db [duplicate]

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related