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.
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.
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 ...