mysql
灬清风无痕灬
做个一有梦想的美男子
展开
-
数据库没有远程权限
报错: 查询 use mysql; select User,authentication_string,Host from user; 语句改变: update user set host = ‘%’ where user = ‘root’; 重启mysql : service mysqld restart原创 2020-09-21 16:52:05 · 135 阅读 · 0 评论 -
set password for root@localhost = password(‘123‘); 出错
在数据库命令行里,输入: mysql> set password for root@localhost = password('123'); 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 to use near 'password('123')' at l原创 2020-09-21 15:38:45 · 2144 阅读 · 0 评论