mysql
攻城师论坛
这个作者很懒,什么都没留下…
展开
-
InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMIT
1.起因使用django连接mysql进行数据库操作的时候出现以下错误InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMIT2.解决方案连续执行以下命令SET GLOBAL binlog_format = 'STATEME...原创 2019-08-18 17:38:16 · 1511 阅读 · 0 评论 -
CentOS7 OR Linux安装mysql8.0数据库
CentOS默认安装了MariaDB数据库,这是属于mysql的一个分支,安装之前需要将相应的依赖包进行删除干净,否者否出现各种异常0 .起因yum install mysql-community-server.x86_64使用上述命令安装mysql,出现各种错误错误信息如下You could try using --skip-broken to work around ...原创 2019-08-18 18:18:11 · 419 阅读 · 0 评论 -
Your password does not satisfy the current policy requirements 修改mysql密码出现的错误
0.起因安装mysql8.0使用临时密码登录后,提示修改密码根据提示修改mysql密码update user set password=password(‘123’) where user='root'出现错误ERROR 1819 (HY000): Your password does not satisfy the current policy requirements...原创 2019-08-18 18:37:59 · 23211 阅读 · 8 评论 -
mysql8.0修改用户权限使用外网连接
一.配置用户权限1.查看用户目前的权限use mysql;select Host,User from user where user='root';我这里已经开放了外网权限,没有开放%显示的是localhost2.修改Host为%,代表外网可以连接,并刷新update user set Host='%' where User ='root';FLUSH PR...原创 2019-08-18 18:47:01 · 4084 阅读 · 0 评论