我运行了 /usr/bin/mysqldump -uroot –phuningfei cacti > /tmp/cacti.sql
错误提示:
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using pas sword: NO) when trying to connect
我的root账户权限和密码都没问题,不知道是那里出错了?
错误提示:
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using pas sword: NO) when trying to connect
我的root账户权限和密码都没问题,不知道是那里出错了?
0
不行 ,还是这样
/
maria 发表于 2016-5-5 11:53
试试/usr/bin/mysqldump -uroot –p cacti > /tmp/cacti.sql,回车然后输入密码
不行 ,还是这样
/
- usr/bin/mysqldump -uroot –p cacti > /tmp/cacti.sql
- mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using pas sword: NO) when trying to connect
0
http://www.apelearn.com/bbs/thread-10561-1-1.html
1045:不能连接数据库,用户名或密码错误
mysql -uroot -p
mysql> GRANT ALL PRIVILEGES ON cacti.* TO 'hnf@'localhost' IDENTIFIED BY 'hnf@2014';
mysql> flush privileges;
mysql>exit
截图
mysqldump -uhnf -p cacti > /tmp/cacti.sql
截图
1045:不能连接数据库,用户名或密码错误
mysql -uroot -p
mysql> GRANT ALL PRIVILEGES ON cacti.* TO 'hnf@'localhost' IDENTIFIED BY 'hnf@2014';
mysql> flush privileges;
mysql>exit
截图
mysqldump -uhnf -p cacti > /tmp/cacti.sql
截图
0
厉害,我执行了GRANT ALL PRIVILEGES ON cacti.* TO 'hnf@'localhost' IDENTIFIED BY 'hnf@2014';
这个之后备份居然不提示了,之前我也授权了,用的是grant all on *.* to 'root'@'localhost' identified by 'huningfei'; ,居然不行
乐橙306 发表于 2016-5-5 13:17
http://www.apelearn.com/bbs/thread-10561-1-1.html
1045:不能连接数据库,用户名或密码错误
厉害,我执行了GRANT ALL PRIVILEGES ON cacti.* TO 'hnf@'localhost' IDENTIFIED BY 'hnf@2014';
这个之后备份居然不提示了,之前我也授权了,用的是grant all on *.* to 'root'@'localhost' identified by 'huningfei'; ,居然不行
0
解决了就好
渐行渐远 发表于 2016-5-5 13:29
厉害,我执行了GRANT ALL PRIVILEGES ON cacti.* TO 'hnf@'localhost' IDENTIFIED BY 'hnf@2014';
这个 ...
解决了就好
编辑回复