创设mysql DB用户

root
abc abc
  • 10 Aug

创建数据库，设置字符

CREATE DATABASE mydb CHARACTER SET utf8mb4; #此处utf8应该改为：

创建用户及密码

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';

授权

GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost' IDENTIFIED BY 'mypass'

  • Page 1 of 1
Reply