Do I support CREATE rights after DROP DATABASE in MySQL?

Question

I have a user in MySQL with the following privileges:

GRANT USAGE ON *.* TO 'certain_db'@'192.168.1.1' IDENTIFIED BY PASSWORD '****' GRANT ALL PRIVILEGES ON `certain_db`.* TO 'certain_db'@'192.168.1.1' 

If I drop this database, do I retain the right to create it later?

Answer 1

Yes. All information related to user access, privileges, etc., is stored in a database named "mysql". Information related to database privileges is stored in the 'db' table. When you delete a database, your rights to it are not deleted. So, if you want to create a database with this name later, you can.