本篇文章自己亲自尝试成功,并且附上自己操作过程参考的博文,包括出现错误的处理方法或博客
配置Mysql8.0
由于自己的mysql版本比较落后了,所以下载并配置了最新的Mysql8.0版本。
超详细MySQL安装及基本使用教程:
https://blog.csdn.net/bobo553443/article/details/81383194
安装SQLYog5.5时报如下错: Client does not support authentication protocol requested by server; consider upgr:
https://blog.csdn.net/lvtula/article/details/81699611
mysql查看、修改端口、指定端口登录:
https://blog.csdn.net/cbbbc/article/details/46398533?depth_1-utm_source=distribute.pc_relevant.none-task&utm_source=distribute.pc_relevant.none-task
更换密码操作:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你自己需要设定的密码';
我的端口号是更改的,3307,我的登陆方式:
mysql -h localhost -u root -p你自己的密码 -P3307
解决Navicat连接MySQL出现1251-Client does not support authentication protocol requested by server;:
https://blog.csdn.net/qq_38455201/article/details/83024357
vs2019下配置mysql
配置过程,代码部分不清楚是否可以成功:Visual Studio 2019 C++ 连接 MySQL 8.0.18 方法
https://blog.csdn.net/TonyWangAlfa/article/details/104789271
找不到libmysql.dll的解决办法:
https://blog.csdn.net/iteye_15306/article/details/81617786
代码运行时无法解析的外部符号:(两个地方,建议都尝试一下)
https://bbs.csdn.net/topics/390523114?list=986822
https://blog.csdn.net/w20175357/article/details/42152217