mysql搭建以及调优

搭建：
http://www.runoob.com/mysql/mysql-install.html
调优：
http://zhou123.blog.51cto.com/4355617/1152994
https://blog.linuxeye.com/379.html

Windows安装mysql

1、以管理员身份运行cmd
2、安装
https://www.runoob.com/mysql/mysql-install.html
3、client does not support authentication protocal rquested by server

USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';
FLUSH PRIVILEGES;

4、修改密码

alter user root@localhost identified by '123'

5、安装遇到的问题

安装MySQL提示“找不到msvcp140.dll”

原因是没有安装VC++2015的版本库。下载地址：https://www.microsoft.com/en-us/download/details.aspx?id=53587。点击下载、安装相应版本的文件即可。

6、安装vc++库遇到0x80240017错误

https://blog.csdn.net/neochan1108/article/details/78084073

Windows 10系统如何全面的卸载MySQL 8.0.13
https