编辑/etc/my.cnf增加:
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
[client]
default-character-set=utf8
建数据库的时候这样建django插入中文数据就不会出错了:
CREATE SCHEMA `xtyw` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
这样django录入数据库数据时就不会出现乱码
----------------------------------------
首先,尝试在shell下连接,下图是连接成功,
如果防火墙未通过会显示(10065)错误:
"Can't connect to MySQL server on '192.168.46.166' "
如果防火墙通过但是权限阻止会显示(1045)错误:
"Access denied for user 'root'@'192.168.46.166' (using password: YES)"
如何才能允许特定IP或者所有IP用特定的密码远程连接呢?
先看一下user表,mysql将权限等存在user表中,如下图
最后一个表就是user
我们用:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.46.165' IDENTIFIED BY 'yuan';
例如上边这句,允许192.168.46.165用yuan作为密码来访问登录root用户
如果把“192.168.....”换成“%”则是允许任意IP访问:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yuan';
或者
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user;
上边两句均通过写入数据到user表中使生效