0

I want to code an application which, when it runs for the first time on a user's machine, will create a new database, then create a new user and grant it access to the database.

I can manage that, but I want only that user and no other to be able to access the database.

So, just in case the existing installation has superuser where root has access to everything, I would like to revoke for all but the newly created user.

How do I do that?

I am guessing something like

REVOKE ALL PRIVILEGES, GRANT OPTION FROM mysql.user WHERE user<>[single user name] but can't seem to get it right.

I guess that I have to FLUSH PRIVILEGES afterwards?

Improve this question

1 Answer 1

Reset to default
1

You can ONLY give privileges to access database for your user - using GRANT command.

All other users, except root users, should not have such privileges.

Do you need to run FLUSH PRIVILEGES after GRANT/REVORE? No, you do not need. That is all)

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

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.