
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 · 523 阅读 · 0 评论 -
记录mySql9忘记密码后如何免密登8.0.1,同时修改mysql的免密
执行以下命令net stop mysqlmysqld --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 · 492 阅读 · 0 评论