登录
$ mysql -u root -h xx.xx.xx.xx -P 3306 -p"XXX"
建库
CREATE DATABASE IF NOT EXISTS databasename DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
DEFAULT CHARSET utf8 代表默认编码
COLLATE utf8_general_ci 代表数据库的校验规则,ci是case insensitive的缩写,意思是大小写不敏感,相对的是cs,即case sensitive,大小写敏感;
utf8_bin,是将字符串中的每一个字符用二进制数据存储,区分大小写
授权
select user,host from mysql.user;
grant all privileges on databasename .* to username@'xx.xx.xx.xx' identified by 'XXX';
grant all privileges on databasename .* to username@'%' identified by 'XXX';
flush privileges;