安装数据库教程

win系统：

四款数据库可视化操作工具：https://blog.csdn.net/tian330726/article/details/83716337

1.windows10 上安装mysql数据库及Navicat 中连接数据库：https://www.cnblogs.com/yudx/p/12753246.html

2.mysql的msi安装：https://blog.csdn.net/zhangtao0417/article/details/90377341
更详细：https://www.cnblogs.com/clschao/articles/9916971.html
更换数据和文件地址：https://m.php.cn/article/460714.html

3.Navicat微软系统安装激活下载地址：https://wwi.lanzoui.com/ifGWrpwlvih
sqlyog下载：https://wwt.lanzouj.com/iMD6ozunpkd

4.显示文件后缀设置：https://product.pconline.com.cn/itbk/software/dnwt/1510/7093097.html#ad=7094
mysqld -remove是移除mysql，卸载的时候有用

5.四款数据库可视化操作工具:https://blog.csdn.net/tian330726/article/details/83716337

6.如何彻底卸载清理MySQL：https://blog.csdn.net/u014565127/article/details/90551593

7.mysql workbench：https://blog.csdn.net/qq_51976738/article/details/118862777

8.解决MySQL安装3306端口占用问题https://www.cnblogs.com/tansuozhe/p/12820232.html

9.1251 client does not support authentication protocol requested by server；co 报错解决方案https://blog.csdn.net/xuelang532777032/article/details/101396659

10.Start Server 失败
https://blog.csdn.net/qq_40542692/article/details/81012594
https://blog.csdn.net/zhuangg55/article/details/98704537
https://blog.csdn.net/wdr2003/article/details/84824870

11.VC++2015-2019:
https://docs.microsoft.com/zh-CN/cpp/windows/latest-supported-vc-redist?view=msvc-170
https://www.cnblogs.com/zc520/p/12520227.html

12.安装MySQL时在Initializing database步骤出错的解决办法https://blog.csdn.net/Staystrong138/article/details/119766392

13.忘记密码处理方法：
https://www.cnblogs.com/ttxcs/p/11614391.html
https://www.cnblogs.com/Lints/p/11506902.html
https://www.cnblogs.com/wangjiming/p/10363357.html

14.端口被占用处理方法：https://www.php.cn/php-weizijiaocheng-378543.html

15.netframwork4.52：https://www.microsoft.com/zh-CN/download/confirmation.aspx?id=42642

16.修改编码：https://blog.csdn.net/Fristm/article/details/121908439（成功，修改后#要去掉）
1.https://blog.csdn.net/yelllowcong/article/details/79095799
2.https://blog.csdn.net/u012004128/article/details/79911869
3.https://blog.csdn.net/qq_34694342/article/details/86703068
4.https://blog.csdn.net/weixin_30043049/article/details/113714596

17MySQL常用show命令：https://www.cnblogs.com/andy6/p/6171945.html

18.MySQL 1130错误原因及解决方案：https://blog.csdn.net/nayun123/article/details/117128159
https://zhuanlan.zhihu.com/p/374184495
服务器放行3306端口：https://blog.csdn.net/weixin_43296313/article/details/127996612
1044错误解决：https://blog.csdn.net/qq_54928486/article/details/125666293

19.mysql安全路径问题：https://www.cnblogs.com/missmzt/p/7676800.html

MAC系统

1.mac安装mysql的两种方法（含配置）：https://www.jianshu.com/p/fd3aae701db9

2.MySQL for mac傻瓜式教程https://blog.csdn.net/qq_37832848/article/details/82902522?spm=1001.2101.3001.6650.5

3.最实用：https://blog.csdn.net/qq_42499672/article/details/107910100

4.配置环境变量：
https://www.cnblogs.com/pariese/p/7467502.html
https://www.cnblogs.com/zhiaiyaner/p/14958207.html（成功）
https://www.cnblogs.com/lzh1043060917/p/15478639.html
https://blog.csdn.net/Chad97/article/details/102533405

5.文件损坏处理办法：https://zhuanlan.zhihu.com/p/114919138

6.忘记密码后重置密码：https://www.cnblogs.com/lihuanqing/p/5623872.html
Mac安装MySQL没有默认密码解决：https://www.pianshen.com/article/1434279673/
没有密码：https://blog.csdn.net/wildand/article/details/122365870（成功）

7.mac数据库清理干净：
https://blog.csdn.net/wqdwin/article/details/75110045
https://blog.csdn.net/qq_35106903/article/details/78875781
Mac下干净彻底地卸载MySQL：https://www.jianshu.com/p/276c1271ae14

8.Mac下MySQL workbench意外退出：https://blog.csdn.net/qq_39081114/article/details/113275275
macserver无法启动问题：https://blog.csdn.net/weixin_43473420/article/details/120467240

9.mac上系统偏好里无法停止mysql：https://www.cnblogs.com/yalong/p/14136997.html

10.解决MAC下修改系统文件没权限的问题：https://www.jianshu.com/p/e5ff582502af

11.每次都要执行source ~/.bash_profile才有效：https://blog.csdn.net/lanlangaogao/article/details/118928478

Linux安装mysql教程：

1.CentOS7.9使用yum方式安装mysql8.0.27（2022最新版）
https://www.cnblogs.com/oldboy666/p/15559963.html

2.CentOS7安装MySQL8.0图文教程
https://www.cnblogs.com/yanglang/p/10782941.html
Ubuntu安装MySQL8.0：https://blog.csdn.net/weixin_44129085/article/details/104481986

3.Linux虚拟机详细安装MySQL
https://www.cnblogs.com/chenyanbin/p/13144042.html

4.Linux环境下MySQL安装部署操作步骤
https://blog.csdn.net/weixin_43184774/article/details/109576986

5.CentOS8更换yum源：https://blog.csdn.net/u011630259/article/details/104001808

6.linux阿里云服务器centos8操作系统安装mysql8.0详细教程
https://blog.csdn.net/qq_41688840/article/details/104699628

7.查看密码
https://www.cnblogs.com/love-wife/p/10881300.html

8.linux忘记密码解决方案
https://www.cnblogs.com/black-fact/p/11613361.html

9.宝塔数据库开启root权限：https://blog.csdn.net/qq_37468919/article/details/114936706
宝塔面板允许Navicat for MySQL使用root账号远程连接mysql数据库：https://blog.csdn.net/qq15577969/article/details/118726168