mysql 创建数据库

1、 CREATE DATABASE 数据库名;

2、CREATE USER '用户名'@'%' IDENTIFIED WITH mysql_native_password AS '密码';GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;GRANT ALL PRIVILEGES ON `数据库名`.* TO '用户名'@'%';