-- 1.创建用户
CREATE USER 'thinknet'@'%' IDENTIFIED BY 'thinknet1234';
-- 2.创建数据库,并设置编码格式
CREATE DATABASE `TNd_platform` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-- 3.给thinknet用户赋予权限,所有权限
grant all privileges on *.* to thinknet@'%' identified by 'thinknet1234' WITH GRANT OPTION;
-- 4.给root用户赋予所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'thinknet1234' WITH GRANT OPTION;
-- 5.导入sql文件,【小提示:可能之前需要你use yourdb;】
source d:/data.sql;
CREATE USER 'thinknet'@'%' IDENTIFIED BY 'thinknet1234';
-- 2.创建数据库,并设置编码格式
CREATE DATABASE `TNd_platform` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-- 3.给thinknet用户赋予权限,所有权限
grant all privileges on *.* to thinknet@'%' identified by 'thinknet1234' WITH GRANT OPTION;
-- 4.给root用户赋予所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'thinknet1234' WITH GRANT OPTION;
-- 5.导入sql文件,【小提示:可能之前需要你use yourdb;】
source d:/data.sql;