新建数据库并授权给用户

新建数据库
>CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

对于mysql的旧版本：

>grant all privileges on dbname.* to 'phplamp'@'%' identified by '123456';
>flush privileges;

对于mysql8.0版本要这样：
mysql> CREATE USER 'phplamp'@'%' IDENTIFIED BY '123456';

mysql> grant all privileges on dbname.* to 'phplamp'@'%';

mysql> flush privileges;

 删除用户

DROP USER 'phplamp'@'%' ;