Mysql
万能的小土豆
PHP网站编程,App(ios)编程,欢迎大家随时撩我
展开
-
Mysql8 :客户端连接caching-sha2-password问题
处理: ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码 FLU...原创 2018-12-14 22:15:23 · 209 阅读 · 0 评论 -
Mysql解锁行锁定
1.查看下在锁的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;2.杀死进程id(就是上面命令的trx_mysql_thread_id列)kill 线程ID原创 2018-12-15 13:13:53 · 234 阅读 · 0 评论