create database foo_db;
create user foo_user identified by ‘foo_password‘;
grant all on foo_db.* to ‘foo_user‘@‘%‘;
flush privileges;
create database foo_db;
create user foo_user identified by ‘foo_password‘;
grant all on foo_db.* to ‘foo_user‘@‘%‘;
flush privileges;
add user and grant privileges on mariadb
原文：http://www.cnblogs.com/LicwStack/p/5819166.html