2
votes
2answers
190 views

How to grant permission to new user created in mysql?

I want to create new user and want to give them specific permission like inset, update and delete. But how to create new user and give them permission i don't know. Any help please.
0
votes
1answer
50 views

Drop privilege to tables only, Not to database

I created a user with drop privilege to a database. How can I create a user who has the privilege to drop tables of a specified database, but not database.
3
votes
1answer
7k views

How do I automatically grant all privileges to a schema created by a user in mysql?

Someone new joined the company and I created an account for her in mysql using the following: CREATE USER 'username' IDENTIFIED BY 'password' She needs to create her own schema and so used: GRANT ...