blocks|key|921069|text|您必须以管理员身份运行CMD.EXE：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|921070|右键单击cmd.exe+-->以管理员身份运行，然后键入命令：|921071|mysqldump+-uusername+-ppassword+-hip或命名数据库名称c:\sqlfile.sql+>mysqldump|921072|它应该工作得很好。|921073|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

You have to run CMD.EXE as the Administrator:

Right click on cmd.exe --> Run as Administrator and then type your command:

mysqldump -u[username] -p[password] -h[ip or name] yourdatabasename > c:\sqlfile.sql

It should work fine.

blocks|key|704672|text|我知道这个话题很古老，但我碰巧也有同样的问题。我发现问题出在密码中使用的特殊字符。事实上，它们必须使用反斜杠：--password=123\@456或使用单引号--password='123@456'进行转义|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|704673|entityMap^0|1J|J|28|K|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

I know the topic is very old, but I happened to have the same issue. I figured out that the problem was just the special character used in the password. In fact they must be escaped with the anti slash: <code>--password=123\@456</code> or using signle quotes <code>--password='123@456'</code>

blocks|key|921014|text|我在通过Plesk创建的DB用户上也遇到了同样的问题。用户拥有对单个数据库的权限。如果我指定数据库名称，我会得到上面提到的错误。如果我为所有数据库指定-A，转储就会正常工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|921015|entityMap^0|23|2|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

I had the same problem with a DB user created via Plesk. The user has permissions for a single database. If I specify the database name I get the error mentioned above. If I specify <code>-A</code> for all databases, the dump works.

blocks|key|921147|text|在windows中，我通过创建一个目录，然后在备份目录中转储*.sql文件来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|921148|C:\backup|offset|length|style|CODE|921149|命令没有问题：|921150|去掉方括号|921151|mysqldump+-u[username]+-p[password]+-h[ip]+yourdb+>+C:\backup\sqlfile.sql|921152|它对我很有效：)|921153|entityMap^0|0|0|9|0|0|0|0|21|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|Q|$]]

In windows, I resolved it by making a directory and then dumping *.sql file in backup directory. 

<code>C:\backup</code> 

There are no issues with commands : 
 Remove the [ ] square brackets

<code> mysqldump -u[username] -p[password] -h[ip] yourdb > C:\backup\sqlfile.sql</code>

It worked for me:)

blocks|key|921171|text|另一个可能的原因是您试图创建转储的位置。用mysqldump+-u[username]+-p+yourdb+>+D:\backup\sqlfile.sql代替mysqldump+-u[username]+-p+yourdb+>+sqlfile.sql解决了我的问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|921172|entityMap^0|L|1K|27|1A|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

One more possible cause can be the place you are trying to create dump.
Writing <code>mysqldump -u[username] -p yourdb &gt; D:\backup\sqlfile.sql</code> instead of <code>mysqldump -u[username] -p yourdb &gt; sqlfile.sql</code> resolved my problem.

blocks|key|704509|text|连接选项没有=+(等号)。您需要以下内容。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|704510|mysqldump+-u+test+-ppassword+-h+10.64.1.2+...|code-block|syntax|javascript|704511|有关其他选项的更多详细信息，请查看the+docs。|704512|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html^0|6|1|0|0|H|8|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

There is no <code>=</code> (equal sign) for the connection options. You want the following.

<pre><code>mysqldump -u test -ppassword -h 10.64.1.2 ...
</code></pre>

Check out <a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html" rel="nofollow">the docs</a> for more details on the other options.

blocks|key|704702|text|以下是对我有效的方法--以admin身份运行cmd+line。不要将任何密码放在-p后面，系统会自动提示您输入密码，它会起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|704703|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Heres what worked for me- run cmd line as admin.
dont put any password after -p, you are automatically prompted to enter a password and it works.

blocks|key|921188|text|尝试使用此命令|type|unstyled|depth|inlineStyleRanges|entityRanges|data|921189|mysqldump+--user=root+-p+--host=127.0.0.1+--databases+database_name+[database_name_2,...]+>+dump.sql|code-block|syntax|javascript|921190|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Trying with this command

<pre><code>mysqldump --user=root -p --host=127.0.0.1 --databases database_name [database_name_2,...] &gt; dump.sql
</code></pre>

blocks|key|921218|text|问题是需要额外访问权限才能在C:/+location中创建文件，所以请尝试使用其他方法，如:+mysqldump+-u+root+-p+cricket+classics+>+C:\Users\habib_s9ayvfl\Desktop\classics.sql|type|unstyled|depth|inlineStyleRanges|entityRanges|data|921219|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The problem is that there need additional access to create file in C:/ location so try to use other like for me it resolve by :
mysqldump -u root -p cricket classics &gt; C:\Users\habib_s9ayvfl\Desktop\classics.sql

When I try to backup using mysqldump from ssh,
I run the following command on machine 10.64.1.1. It gives the following error.

<code>mysqldump --user=test -p=password --host=10.64.1.2 --tab=. databasename tablename</code>

<code>mysqldump: Got error: 1045: Access denied for user 'test'@'10.64.1.1' (using password: YES)</code> when trying to connect

However, I can access mysql using the same user and password.

<code>mysql --user=test -p[password]</code>

Current user: <code>test@10.64.1.1</code>

SSL: <code>Not in use</code>

Current pager: <code>stdout</code>

Using outfile: <code>''</code>

Using delimiter: <code>;</code>

Server version: <code>5.0.91-50-log Percona SQL Server, Revision 73 (GPL)</code>

Protocol version: <code>10</code>

Connection: <code>10.64.1.2 via TCP/IP</code>

Updates:

If I do following mysql document: <code>--password[=password]</code> or <code>-p[password]</code>. 

Since my password contains special symbol <code>@</code>, Mysql cannot detect user correctly. It complains:

<code>mysqldump: Got error: 1044: Access denied for user 'test'@'%' to database</code>

mysqldump access denied

SQL Server

数据库

服务器

当我尝试从ssh使用mysqldump进行备份时，我在计算机10.64.1.1上运行以下命令。它会给出以下错误。mysqldump --user=test -p=password --host=10.64.1.2 --tab=. databasename tablename尝试连接时的mysqldump: Got error: 1045: Access denied for user 'test'

问mysqldump访问被拒绝
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqldump访问被拒绝EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqldump访问被拒绝
EN