try adding a -u<someuser> (--user=) and -p, this will tell the mysql
server what user you are connecting as and it will prompt you for a
password.
It could be many other things though, depending on how you have set up
your access tables. It's usually a bad idea to not restrict connections by
either host or password (preferrably both!)
On Wed, 10 Jan 2001, Web Master wrote:
> Hello,
>
> can any one help me with my following mysqldump question.
>
> I want to dump a complete database from one server to another server. I am
> trying the following comment
>
> mysqldump --opt mydatabase | mysql --host=remotehost -C mydatabase
>
> when I tried, the remote host is failing with invalid log in.
> Can any one help me, how I can enter the remote uid and pwd in the same dump?
>
> Thanks in advance
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to:
> <[EMAIL PROTECTED]>
>
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
>
--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to:
<[EMAIL PROTECTED]>
If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
http://lists.mysql.com/php/unsubscribe.php