s1s2:/usr/local/mysql # mysql -uroot -p wanpiao88 < wanpiao88.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[b]解决办法如下:[/b]
这是由于访问权限不够,
mysql> [b][color=blue]grant all on *.* to root@'%' identified by "123456";[/color][/b]
Query OK, 0 rows affected (0.00 sec)
mysql> [b][color=blue]flush privileges;[/color][/b]
Query OK, 0 rows affected (0.00 sec)
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[b]解决办法如下:[/b]
这是由于访问权限不够,
mysql> [b][color=blue]grant all on *.* to root@'%' identified by "123456";[/color][/b]
Query OK, 0 rows affected (0.00 sec)
mysql> [b][color=blue]flush privileges;[/color][/b]
Query OK, 0 rows affected (0.00 sec)