更改数据库Alter Database
ALTER [DATABASE|SCHEMA] db_name SET DBPROPERTIES (key=val, ...)
SET DBPROPERTIES
为数据库指定名为 key
的属性,并将该属性的值设置为 val
。Specify a property named key
for the database and establish the value for the property respectively as val
. 如果 key
已存在,则 val
将覆盖旧值。If key
already exists, the old value is overwritten with val
.
分配所有者Assign owner
ALTER DATABASE db_name OWNER TO `user_name@user_domain.com`
为数据库分配所有者。Assign an owner to the database.