create database dbname default character set utf8 collate utf8_general_ci;
create user 'userid'@'%' identified by '1234';
grant all privileges on dbname .* to 'userid'@'%';
flush privileges;
create database dbname default character set utf8 collate utf8_general_ci;
create user 'userid'@'%' identified by '1234';
grant all privileges on dbname .* to 'userid'@'%';
flush privileges;