mysql 创建用户和数据表

create database zanhu charset utf8;  
 create user 'zanhu'@'%' identified by 'zanhu123456+'; 
grant all on zanhu.* to 'zanhu'@'%';  #给数据库zanhu的所有表赋予所有权限。
flush privileges;