![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
文章平均质量分 59
xiaoxianerqq
这个作者很懒,什么都没留下…
展开
-
navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案
今天安装了navicat 和 mysql,结果最后在navicat中连接mysql时,出现了如下错误提示:Client does not support authentication protocol requested by server; consider upgrading MySQL client1网上找了如下方法:其一:mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpw...转载 2021-09-08 18:48:59 · 374 阅读 · 0 评论 -
navicat: Client does not support authentication protocol requested by server;
版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。本文链接:https://blog.csdn.net/zhangjing0320/article/details/91045149参考:https://www.cnblogs.com/zichuan/p/9203129.html本人用的方法一解决的问题:Navicat连接MySQL...转载 2019-12-04 16:08:10 · 327 阅读 · 0 评论 -
navicat 连接不上虚拟机上的mysql容器 client does not support authentication protocol requested by server; consid
版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。本文链接:https://blog.csdn.net/yubin1285570923/article/details/83352491一、问题产生在centOS 通过docker pull mysql下载mysql镜像并成功启动mysql容器。当通过windows主机navicat连接...转载 2019-12-04 15:41:22 · 181 阅读 · 0 评论 -
学会这15点,让你分分钟拿下Redis数据库
转自:https://www.toutiao.com/a6586229650249220622/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533586471&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-07 09:33:45 · 197 阅读 · 0 评论 -
Redis 源码学习之 Redis 事务
转自:https://www.toutiao.com/a6586230990916551182/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533603003&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-07 09:32:20 · 121 阅读 · 0 评论 -
MySQL 字符转化以及乱码原因
转自:https://www.toutiao.com/a6584762320675668488/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533169479&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-02 09:09:59 · 490 阅读 · 0 评论 -
通过Nginx+tomcat+redis实现反向代理 、负载均衡及session同步
转自:https://www.toutiao.com/a6584760895132402179/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533169261&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-02 09:09:25 · 153 阅读 · 0 评论 -
redis优势这么多,为什么没有吧memcache干掉?
转自 :https://www.wukong.com/answer/6532702694623150340/?iid=39055545733&app=news_article&share_ansid=6532702694623150340&app_id=13&tt_from=mobile_qq&utm_source=mobile_qq&utm_med...转载 2018-08-02 09:08:34 · 4381 阅读 · 0 评论 -
mysql死锁以及死锁日志分析
转自 :https://www.toutiao.com/a6584762452099990030/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533169309&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-02 09:07:51 · 15827 阅读 · 0 评论 -
怎么理解SQL的四个事务隔离级别?
转自:https://www.wukong.com/answer/6589612365552025860/?iid=40708017633&app=news_article&share_ansid=6589612365552025860&app_id=13&tt_from=mobile_qq&utm_source=mobile_qq&utm_medi...转载 2018-08-15 09:22:29 · 8826 阅读 · 0 评论 -
为什么开发人员必须要了解数据库锁?
转自 :https://www.toutiao.com/a6588380916211515917/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533985691&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-13 09:31:46 · 417 阅读 · 0 评论 -
十招搞定 MySQL 大规模数据库的性能和伸缩性优化
转自 :https://www.toutiao.com/a6589931564392514056/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1534378978&app=news_article&utm_source=mobile_qq&iid=40708017633&utm_med...转载 2018-08-16 09:31:21 · 510 阅读 · 0 评论 -
MySQL 线程池内幕
转自 :https://www.toutiao.com/a6589931171583361544/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1534379442&app=news_article&utm_source=mobile_qq&iid=40708017633&utm_me...转载 2018-08-16 09:32:13 · 916 阅读 · 0 评论 -
MySQL order by 原理以及优化?
转自:https://www.toutiao.com/a6590320092066611715/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1534463418&app=news_article&utm_source=mobile_qq&iid=40708017633&utm_medi...转载 2018-08-21 09:54:12 · 213 阅读 · 0 评论 -
linux mongodb安装和配置启动图文详解
转自 :https://www.cnblogs.com/lanbosm/articles/8312725.html一.前期准备Win10环境下 官网下载Mongodb包 https://www.mongodb.com/download-center?jmp=nav 本文使用 https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-ama...转载 2018-09-17 10:30:42 · 218 阅读 · 0 评论 -
mysql中隔离级别和锁有什么关系?
转自 :https://www.wukong.com/answer/6603702542973010183/?iid=43974241203&app=news_article&share_ansid=6603702542973010183&app_id=13&tt_from=mobile_qq&utm_source=mobile_qq&utm_med...转载 2018-09-25 09:14:27 · 390 阅读 · 0 评论 -
深究分布式缓存的九个点
转自 :https://www.toutiao.com/a6605069469083501064/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1537923993&app=news_article&utm_source=mobile_qq&iid=43974241203&utm_med...转载 2018-09-26 09:35:42 · 188 阅读 · 0 评论 -
MySQL数据恢复的九把瑞士军刀
转自:https://www.toutiao.com/a6584762606844641795/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533169169&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-02 09:07:11 · 389 阅读 · 0 评论 -
一文看懂Redis的持久化原理
转自 :https://www.toutiao.com/a6589213078594781703/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1534206327&app=news_article&utm_source=mobile_qq&iid=40708017633&utm_med...转载 2018-08-14 09:39:06 · 138 阅读 · 0 评论 -
Redis深度历险——核心原理与应用实践
转自: https://www.toutiao.com/a6587193839872639496/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533761453&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-09 09:27:39 · 11055 阅读 · 2 评论 -
DBA的MySQL性能优化及自动化运维实践
转自:https://www.toutiao.com/a6587255614248845831/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533731005&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-09 09:28:21 · 1234 阅读 · 0 评论 -
数据库分析分哪几步骤,各阶段任务有哪些?
转自:https://www.wukong.com/answer/6584923428715757832/?iid=39055545733&app=news_article&share_ansid=6584923428715757832&app_id=13&tt_from=mobile_qq&utm_source=mobile_qq&utm_medi...转载 2018-08-05 09:29:47 · 3547 阅读 · 0 评论 -
数据库不适合Docker及容器化的7大原因
转自:https://www.toutiao.com/a6585475568601399821/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533336014&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-05 09:53:47 · 1030 阅读 · 0 评论 -
记录一次 MySQL 死锁排查过程
转自 :https://www.toutiao.com/a6585475405505888775/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533336891&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-05 09:56:15 · 243 阅读 · 0 评论 -
可能是目前最详细的Redis内存模型及应用解读
转自 :https://www.toutiao.com/a6585498415822537229/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533335951&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-05 09:57:13 · 173 阅读 · 0 评论 -
MySQL开发者都应该了解的12个技巧
转自:https://www.toutiao.com/a6585470010418790916/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533336051&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-05 09:57:44 · 126 阅读 · 0 评论 -
Oracle DBA做SQL优化的最佳思路
转自:https://www.toutiao.com/a6585470552448696835/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533336845&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-05 09:58:22 · 644 阅读 · 0 评论 -
Redis事务模式演示
转自:https://www.toutiao.com/a6584334649290392071/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533083663&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-01 09:55:46 · 202 阅读 · 0 评论 -
MySQL 常用30种SQL查询语句优化方法
转自 :https://www.toutiao.com/a6584386280375714308/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533083170&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-01 09:57:16 · 115 阅读 · 0 评论 -
MySQL 在并发场景下的问题及解决思路
转自 :https://www.toutiao.com/a6584385683824050695/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533083339&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-01 09:59:10 · 333 阅读 · 0 评论 -
10 分钟让你明白 MySQL 是如何利用索引的?
转自 :https://www.toutiao.com/a6584386698820452871/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533083380&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_med...转载 2018-08-01 09:59:52 · 195 阅读 · 0 评论 -
为什么分布式一定要有Redis?
转自 : https://www.toutiao.com/a6563625499220771341/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1532970228&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_me...转载 2018-07-31 09:08:17 · 144 阅读 · 0 评论 -
MySQL 的索引是什么?怎么优化?
转自:https://www.toutiao.com/a6587865733663818247/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533861228&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-10 09:30:36 · 129 阅读 · 0 评论 -
一文分析MySQL 数据库锁定机制
转自:https://www.toutiao.com/a6587866244710400516/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533861304&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-10 09:31:16 · 156 阅读 · 0 评论 -
Redis 源码学习之 Redis 事务
转自:https://www.toutiao.com/a6586230990916551182/?tt_from=mobile_qq&utm_campaign=client_share&timestamp=1533603003&app=news_article&utm_source=mobile_qq&iid=39055545733&utm_medi...转载 2018-08-09 09:14:20 · 158 阅读 · 0 评论