MySQL各版本的區別

https://yq.aliyun.com/articles/607474

http://blog.sina.com.cn/s/blog_62b37bfe0101he5t.html

MySQL版本時間線

https://www.cc1021.com/article/134.html

關于MySQL對數據庫用戶密碼的加密方式

MySQL - ERROR 2059: Authentication plugin 'caching_sha2_password'

https://my.oschina.net/johnsken/blog/1840348

############################################

> show variables like 'default_authentication_plugin';

> select host,user,plugin from mysql.user;

> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'MySQL@123';

> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MySQL@123';

> flush privileges;

############################################

MySQL8.0.11 for Linux7.2 二進制安裝

http://blog.51cto.com/fengfeng688/2141752

MySQL高可用——PXC簡介

http://blog.51cto.com/fengfeng688/2151059

PXC5.7.21 for Linux7.2安裝

http://blog.51cto.com/fengfeng688/2151070

MySQL主從復制與讀寫分離

http://blog.51cto.com/13871362/2331275?source=drh

詳解 MySQL 5.7 新的權限與安全問題

https://my.oschina.net/leejun2005/blog/678202

link:?https://www.jianshu.com/p/05c16d58c60a

表定義：

--數據準備：

--導入數據：

-- 查詢 非RC和非GA版本：

mysql> select * from mysql where rel_type like 'Mile%' or rel_type like 'Dev%' order by 1;

+-------------+------------+-----------------------+

| rel_version | rel_date | rel_type |

+-------------+------------+-----------------------+

| 5.6.0 | NULL | Milestone 5 |

| 5.6.1 | NULL | Milestone 6 |

| 5.6.2 | 2011-04-11 | Developer Milestone |

| 5.6.3 | 2011-10-03 | Milestone 6 |

| 5.6.4 | 2011-12-20 | Milestone 7 |

| 5.6.5 | 2012-04-10 | Milestone 8 |

| 5.6.6 | 2012-08-07 | Milestone 9 |

| 5.7.0 | NULL | MileStone 10 |

| 5.7.1 | 2013-04-23 | MileStone 11 |

| 5.7.2 | 2013-09-21 | MileStone 12 |

| 5.7.3 | 2013-12-03 | MileStone 13 |

| 5.7.4 | 2014-03-31 | MileStone 14 |

| 5.7.5 | 2014-09-25 | MileStone 15 |

| 5.7.6 | 2015-03-09 | MileStone 16 |

| 8.0.0 | 2016-09-12 | Development Milestone |

| 8.0.1 | 2017-04-10 | Development Milestone |

| 8.0.2 | 2017-07-17 | Development Milestone |

+-------------+------------+-----------------------+

17 rows in set (0.00 sec)

-- 查詢自2018年1月主流版本發布的次數：

mysql> SELECT SUBSTRING_INDEX(rel_version,'.',2) Major,COUNT(1) COUNT FROM wuhan.mysql s WHERE s.rel_date >='2018-01-01' GROUP BY SUBSTRING_INDEX(rel_version,'.',2) ORDER BY 1;

+-------+-------+

| Major | COUNT |

+-------+-------+

| 5.6 | 5 |

| 5.7 | 5 |

| 8.0 | 6 |

+-------+-------+

3 rows in set (0.00 sec)

-- 查詢每個主流版本第一有日期的發布日期及其間隔，預測下一個版本發布的大致周期：

--查詢每個edition的發布：

-- 年度版本發布次數：

mysql> SELECT YEAR(rel_date) Y,COUNT(1) cnt FROM wuhan.mysql WHERE rel_date IS NOT NULL

-> GROUP BY YEAR(rel_date) ORDER BY 1;

+------+-----+

| Y | cnt |

+------+-----+

| 2009 | 1 |

| 2010 | 8 |

| 2011 | 14 |

| 2012 | 15 |

| 2013 | 15 |

| 2014 | 15 |

| 2015 | 16 |

| 2016 | 23 |

| 2017 | 13 |

| 2018 | 16 |

| 2019 | 4 |

+------+-----+

11 rows in set (0.00 sec)

NameRelease DateRelease Status

10.4.42019-04-07RC

10.4.32019-02-25RC

10.4.22019-01-29Beta

10.4.12018-12-20Beta

10.4.02018-11-09Alpha

10.3.142019-04-02Stable

10.3.132019-02-21Stable

10.3.122019-01-07Stable

10.3.112018-11-20Stable

10.3.102018-10-04Stable

10.3.92018-08-15Stable

10.3.82018-07-03Stable

10.3.72018-05-25Stable

10.3.62018-04-16RC

10.3.52018-02-26RC

10.3.42018-01-18Beta

10.3.32017-12-23Beta

10.3.22017-10-09Alpha

10.3.12017-08-29Alpha

10.3.02017-04-16Alpha

10.2.232019-03-25Stable

10.2.222019-02-11Stable

10.2.212019-01-02Stable

10.2.202018-12-24Stable

10.2.192018-11-13Stable

10.2.182018-09-25Stable

10.2.172018-08-14Stable

10.2.162018-06-26Stable

10.2.152018-05-18Stable

10.2.142018-03-27Stable

10.2.132018-02-13Stable

10.2.122018-01-04Stable

10.2.112017-11-28Stable

10.2.102017-11-01Stable

10.2.92017-09-28Stable

10.2.82017-08-18Stable

10.2.72017-07-12Stable

10.2.62017-05-23Stable

10.2.52017-04-05RC

10.2.42017-02-17RC

10.2.32016-12-24Beta

10.2.22016-09-27Beta

10.2.12016-07-04Alpha

10.2.02016-04-18Alpha

10.1.382019-02-06Stable

10.1.372018-11-02Stable

10.1.362018-09-08Stable

10.1.352018-08-07Stable

10.1.342018-06-18Stable

10.1.332018-05-09Stable

10.1.322018-03-27Stable

10.1.312018-02-06Stable

10.1.302017-12-22Stable

10.1.292017-11-14Stable

10.1.282017-09-28Stable

10.1.262017-08-10Stable

10.1.252017-07-04Stable

10.1.242017-05-31Stable

10.1.232017-05-03Stable

10.1.222017-03-14Stable

10.1.212017-01-18Stable

10.1.202016-12-15Stable

10.1.192016-11-07Stable

10.1.182016-09-30Stable

10.1.172016-08-30Stable

10.1.162016-07-18Stable

10.1.142016-05-10Stable

10.1.132016-03-25Stable

10.1.122016-02-25Stable

10.1.112016-01-29Stable

10.1.102015-12-24Stable

10.1.92015-11-23Stable

10.1.82015-10-17Stable

10.1.72015-09-09RC

10.1.62015-07-27Beta

10.1.52015-06-04Beta

10.1.42015-04-13Beta

10.1.32015-03-02Beta

10.1.22014-12-07Alpha

10.1.12014-10-17Alpha

10.1.02014-06-30Alpha

參考：

https://dev.mysql.com/doc/relnotes/mysql/5.5/en/

https://dev.mysql.com/doc/relnotes/mysql/5.6/en/

https://dev.mysql.com/doc/relnotes/mysql/5.7/en/

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/

https://downloads.mariadb.org/mariadb/+releases/

link:?https://blog.csdn.net/vkingnew/article/details/89501167

總結

以上是生活随笔為你收集整理的mysql版本 时间_【MySQL】MySQL版本时间线和MySQL各版本的区别的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。