c mysql 新建库_mysql新建数据库及常用操作

老是抄网上别人的东东，不如在这里作个记录，直接找自己的。

新建数据库

CREATE DATABASE `gin-vue-nezha` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

查看所有用户

use mysql;

select host,user from user;

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

输出格式：

+-----------+-----------+

| host | user |

+-----------+-----------+

| % | root |

| localhost | gin |

| localhost | mysql.sys |

| localhost | root |

+-----------+-----------+

4 rows in set

新建用户

create user 'gin-vue-nezha'@'%' identified by 'gin-vue-nezha@123';

删除用户

drop user 'gin-vue-nezha'@'%';

用户赋权

grant all privileges on `gin-vue-nezha`.* to 'gin-vue-nezha'@'%' ;

用户权限生效

flush privileges;

查看用户权限

show grants for 'gin-vue-nezha'@'%';

输出

+------------------------------------------------------------------+

| Grants for gin-vue-nezha@% |

+------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'gin-vue-nezha'@'%' |

| GRANT ALL PRIVILEGES ON `gin-vue-nezha`.* TO 'gin-vue-nezha'@'%' |

+------------------------------------------------------------------+

2 rows in set

Nezha项目的三个SQL

CREATE DATABASE `gin-vue-nezha` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

create user 'gin-vue-nezha'@'%' identified by 'gin-vue-nezha@123';

grant all privileges on `gin-vue-nezha`.* to 'gin-vue-nezha'@'%' ;

flush privileges;