1.登录mysql:
mysql -u root -p
2.输入密码:
3.创建数据库(设置编码和排序方式为utf-8):create database myDB DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
4.给数据库分配用户权限:grant all privileges on myDB .* to 'admin'@'%' identified by 'admin';
5.刷新权限:flush privileges;
其他操作:
1.取消MySQL表大小写敏感以及设置字符编码为utf-8:
修改MySQL安装后的目录配置文件/etc/my.cnf,在[mysqld]下面添加如下配置
[mysqld]
lower_case_table_names=1
character_set_server = utf8