Home > Q&A > body text

thinkphp5.1 prompts 2054 error when connecting to Mysql8.0.12

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

缥缈星云1988 days ago2051

西门大官人2019-05-31 14:22:27

After modification, restart mysql

Thank you, God

— 缥缈星云 · 2019-05-31 14:25:07

God, is there any other way to achieve such a link?

— 缥缈星云 · 2019-05-31 14:27:38

It doesn't work even after restarting. Is there any other way?

— (｢･ω･)｢越 · 2019-06-10 17:25:55

缥缈星云2019-05-31 14:17:53

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

Cancelreply