mysql 创建数据库并设置权限

CREATE DATABASE IF NOT EXISTS `db_name`;

CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON `db_name`.* TO 'root'@'%';
FLUSH PRIVILEGES;