mysql
三月神
这个作者很懒,什么都没留下…
展开
-
MySQL 5.7基于GTID复制的常见问题和修复步骤(一)
【问题一】复制slave报错1236,是较为常见的一种报错Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but themaster has purged...转载 2020-02-12 18:02:30 · 609 阅读 · 0 评论 -
mysql允许任何用户访问
update user set host = '%' where user = 'root';SELECT host, user FROM user; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;FLUSH PRIVILEGES;原创 2013-12-05 13:05:23 · 1891 阅读 · 1 评论 -
this authentication plugin is not supported
修改mysql配置后重启服务[mysqld]# Only allow connections from localhostbind-address = 127.0.0.1default-authentication-plugin=mysql_native_password原创 2019-08-26 07:17:24 · 1700 阅读 · 0 评论