追影

命令行创建数据库

1. mysql -u root -p -e "create database common_ai character set utf8mb4 collate utf8mb4_general_ci;"

复制代码

命令行导入

1. mysql -u root -p common_ai <./test.sql

复制代码

赋权某数据库给某个用户

1. grant all privileges on common_ai.* to 'hall'@'localhost';

复制代码

立即刷新权限

1. flush privileges;

复制代码

创建用户

1. create user 'hall'@'localhost' identified by '你的密码';

复制代码