mysqldump 连接失败不能备份，有大神帮帮忙吗

• 请不要在回答技术问题时复制粘贴 AI 生成的内容

This topic created in 2773 days ago, the information mentioned may be changed or developed.

mysqldump -uroot -hlocalhost -p test >test.sql

报错 1045，查了密码帐号权限应该都没有问题，mysql 可以正常登录，权限也是最大权限
按网上方法给密码加了“”也不行，是不是只有改密码一条路了...

Supplement 1 · Nov 6, 2018

贴一下 root 账户权限和报错信息

------------------------------+
| GRANT SELECT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, R
EFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TA
BLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CR
EATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE ON *
.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '******' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using pas
sword: YES) when trying to connect

Supplement 2 · Nov 7, 2018

看了下配置，发现之前配置数据库的人把端口配置 3307，mysqldump 里还是默认 3306，加了“-P3307 ”解决问题了，内心宛如日了狗，谢谢大家都帮忙了

mysqldump

权限

密码

test

16 replies