![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
BiuBiu__A
这个作者很懒,什么都没留下…
展开
-
解决Mysql报错:QL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonagg
【代码】解决Mysql报错:QL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonagg。原创 2024-02-04 15:33:19 · 421 阅读 · 0 评论 -
记录mySql9忘记密码后如何免密登8.0.1,同时修改mysql的免密
执行以下命令 net stop mysql mysqld --console --skip-grant-tables --shared-memory 打开新的cmd窗口(管理员身份) 直接输入mysql即可 修改密码 ALTER USER "root"@"localhost" IDENTIFIED BY "你的新密码"; 这里可能会报错 ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optio原创 2022-03-01 21:30:42 · 396 阅读 · 0 评论