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 · 119 阅读 · 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 · 2045 阅读 · 0 评论