shroudiwnl的博客

【代码】MySQL启动报错：Different lower_case_table_names settings for server (‘0‘) and data dictionary (‘1‘).

mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported应该是mysql-connector出了问题首先卸载掉mysql-connector：pip uninstall mysql-connector再把mysql-connector-python卸载掉pip uninstall mysql-connector-python重新安装mysq

sqlite3.OperationalError: table addresses has 7 columns but 6 values were supplied 创建表时列名和执行插入语句时的列名要一致。

报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket /var/lib/mysql/mysql.sock’ (2)解决：chmod 777 /var/lib/mysqlservice msyqld restartmysql -u root -p#此处直接点击回车进入，不需要密码mysql> use mysql;Reading table information for completion of

用这个语法改，上面的语法不行。ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';