mysql -创建 用户 和 数据库

CREATE DATABASE test DEFAULT CHARSET UTF8 COLLATE UTF8_GENERAL_CI;
CREATE USER 'test'@'%' IDENTIFIED BY '123456';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX, ALTER ROUTINE, EXECUTE ON test.* TO 'test'@'%' IDENTIFIED BY '123456';
 
grant create routine on test.* to 'test'@'%';

GRANT ALL PRIVILEGES ON test.* TO 'test'@'%' identified by '123456';

FLUSH PRIVILEGES;