thinkphp5.1 prompts 2054 error when connecting to Mysql8.0.12
缥缈星云
缥缈星云 2019-05-31 14:06:34
0
5
2090

Mysql configuration file has modified the default encryption method and still prompts 2054 error:

[mysql]

default-character-set=utf8


[mysqld]

port = 3306

default_authentication_plugin=mysql_native_password

basedir="D:/soft/phptoolbox/COM/../Extensions /MySQL/"

datadir="D:/soft/phptoolbox/COM/../Extensions/MySQL/data/"

character-set-server = utf8

default-storage-engine = MyISAM


缥缈星云
缥缈星云

活到老,学到老,学习学习,继续努力

reply all(2)
西门大官人

After modification, restart mysql

  • reply Thank you, God
    缥缈星云 author 2019-05-31 14:25:07
  • reply God, is there any other way to achieve such a link?
    缥缈星云 author 2019-05-31 14:27:38
  • reply It doesn't work even after restarting. Is there any other way?
    (「・ω・)「越 author 2019-06-10 17:25:55
缥缈星云

Enter the Mysql console and modify the encryption method; reference: https://blog.csdn.net/yi247630676/article/details/80352655 Article

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template