创建数据库，远程访问

 

 

创建数据库：

 CREATE DATABASE IF NOT EXISTS my_db default charset utf8 COLLATE utf8_general_ci;

授权：


grant all privileges on dce_db.* to 'dce'@'%' identified by '123456';

fulsh privileges;

 

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'YpwgdKv2wvSI'  ;