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


缥缈星云缥缈星云1941 days ago2014

reply all(5)I'll reply

  • 西门大官人

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

    After modification, restart mysql

    reply
    0
  • 缥缈星云

    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

    reply
    0
  • Cancelreply