mysql创建数据库账号

mysql> create database jzbank  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql> create user 'jzbank'@'localhost' identified by '123456';

mysql> grant all privileges on jzbank.* to 'jzbank'@'localhost';

mysql> flush privileges;

mysql>show grants for 'jzbank'@'localhost';