01 2021 档案

navicat：mysql8.0 解决ERROR 1064 (42000)报错
摘要：语句授权：GRANT ALL PRIVILEGES ON 数据库名.* ‘username'@'%' identified by ‘123456'; 去除掉identified by '123456': 然后 flush privilegens; 阅读全文
posted @ 2021-01-20 19:30 薰衣草的色彩 阅读(694) 评论(0) 推荐(0)
mysql8修改密码报错：ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
摘要：修改密码时使用：mysql> update user set password=password("123456") where user="root";一直报错： ERROR 1064 (42000): You have an error in your SQL syntax; check the 阅读全文
posted @ 2021-01-18 16:32 薰衣草的色彩 阅读(1097) 评论(0) 推荐(1)