之前小沃写过一篇较为详细的mysql基本操作,如果大家有不熟悉的,请浏览https://www.worldflying.cn/article-id-22.html,这里只是快速记录下新建一个数据库,同时创建一个同名用户并让其拥有对这个数据库完整控制权限的方法。
新建如下:
create database gogs; create user gogs@'%'; create user gogs@'localhost'; set password for gogs@'%'=PASSWORD('BpmLb4PLFGaezre3'); set password for gogs@'localhost'=PASSWORD('BpmLb4PLFGaezre3'); grant all privileges on gogs.* to 'gogs'@'%'; grant all privileges on gogs.* to 'gogs'@'localhost'; flush privileges;
删除如下:
revoke all privileges on gogs.* from 'gogs'@'localhost'; revoke all privileges on gogs.* from 'gogs'@'%'; drop user gogs@'localhost'; drop user gogs@'%'; drop database gogs; flush privileges;
文章作者:沃航科技