`

把数据导入mysql数据库的报错

阅读更多
s1s2:/usr/local/mysql # mysql -uroot -p wanpiao88 < wanpiao88.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决办法如下:
      这是由于访问权限不够,
      mysql> grant all on *.* to root@'%' identified by "123456";
      Query OK, 0 rows affected (0.00 sec)

      mysql> flush privileges;
      Query OK, 0 rows affected (0.00 sec)







分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics