mysql 创建用户及数据库

#mysql -uroot -p

CREATE USER 'username '@'%' IDENTIFIED BY 'aa123';

FLUSH PRIVILEGES;

create database databasename DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

grant all privileges on `databasename `.* to 'username'@'%' identified by 'aa123';

create table `tablename` (

`id` int (11),

`type` varchar (48),

`userId` varchar (192),

`phoneNum` varchar (48),

`createtime` timestamp

);

CREATE USER 'username'@'%' IDENTIFIED BY 'abcdef';

FLUSH PRIVILEGES;

create database databasename DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

grant all privileges on `databasename `.* to 'username'@'%' identified by 'abcdef';

create table `tablename` (

`id` int (11),

`type` varchar (48),

`userId` varchar (192),

`phoneNum` varchar (48),

`createtime` timestamp

);