I have a user in MySQL with the following privileges:
我在MySQL中有一个具有以下权限的用户:
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 maintain the right to create it afterwards?
如果删除此数据库,我是否保留以后创建它的权限?
1 个解决方案
#1
16
Yes. All information related to user access, privileges, etc is stored in a database named 'mysql'. Information related to database privileges is stored in table 'db'. When you drop a database your privileges over it are not deleted. So, if you want to create a database with the SAME name later you will be able to.
是。与用户访问,权限等相关的所有信息都存储在名为“mysql”的数据库中。与数据库权限相关的信息存储在表'db'中。删除数据库时,不会删除对其的权限。因此,如果您想稍后创建具有SAME名称的数据库,您将能够。
#1
16
Yes. All information related to user access, privileges, etc is stored in a database named 'mysql'. Information related to database privileges is stored in table 'db'. When you drop a database your privileges over it are not deleted. So, if you want to create a database with the SAME name later you will be able to.
是。与用户访问,权限等相关的所有信息都存储在名为“mysql”的数据库中。与数据库权限相关的信息存储在表'db'中。删除数据库时,不会删除对其的权限。因此,如果您想稍后创建具有SAME名称的数据库,您将能够。