1.执行mysql命令时出现&＃xff1a;You must reset your password using ALTER USER statement before executing this statement.
解决办法&＃xff1a;
step 1: SET PASSWORD &＃61; PASSWORD(&＃39;your new password&＃39;);
step 2: ALTER USER &＃39;root&＃39;&＃64;&＃39;localhost&＃39; PASSWORD EXPIRE NEVER;
step 3: flush privileges;
2.Python连接mysql数据库出现错误&＃xff1a;_mysql_exceptions.OperationalError: (1045, "Access denied for user &＃39;root&＃39;&＃64;&＃39;localhost&＃39; (using password: YES)")
解决办法&＃xff1a;为创建的数据库赋予权限&＃xff0c;参考mysql创建、删除用户
为用户赋予数据库所有权限
格式&＃xff1a;grant 权限 on 数据库.* to 用户名&＃64;登录主机 identified by "密码";
grant all privileges on my_test.* to root&＃64;localhost identified by &＃39;&＃39;;
flush privileges;
3.linux环境下连接mysql出现错误&＃xff1a;_mysql_exceptions.OperationalError: (2002, "Can&＃39;t connect to local MySQL server through socket &＃39;/var/lib/mysql/mysql.sock&＃39; (2)")
解决办法&＃xff1a;将host为localhost改为127.0.0.1即可
京公网安备 11010802041100号