Forum: Typo [OT] Bleah -- can't dump db

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
C1bcb559f87f356698cfad9f6d630235?d=identicon&s=25 Hal Fulton (Guest)
on 2006-05-10 04:21
(Received via mailing list)
[root@www typo]# mysqldump -u hal9000 -p typo  >backup3.out
Enter password:
mysqldump: Got error: 1045: Access denied for user 'hal9000'@'localhost'
(using
password: YES) when trying to connect


Got any idea what's wrong?


Hal
77727af1cef316b241d106cf4d9fbd96?d=identicon&s=25 Dominic Mitchell (Guest)
on 2006-05-10 10:15
(Received via mailing list)
Hal Fulton wrote:
> [root@www typo]# mysqldump -u hal9000 -p typo  >backup3.out
> Enter password:
> mysqldump: Got error: 1045: Access denied for user 'hal9000'@'localhost' (using
> password: YES) when trying to connect
>
>
> Got any idea what's wrong?

Silly question, but do those parameters exactly match what's in
config/database.yml?  For example, leaving out the hostname on the
mysqldump command /may/ make a difference, because you're connecting
over the local socket.

-Dom
D5face11a4b9e053593de4e6ccf510e0?d=identicon&s=25 Dennis Wegner (Guest)
on 2006-05-10 11:31
(Received via mailing list)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Hal,

Am 10.05.2006 um 04:21 schrieb Hal Fulton:

> [root@www typo]# mysqldump -u hal9000 -p typo  >backup3.out
> Enter password:
> mysqldump: Got error: 1045: Access denied for user
> 'hal9000'@'localhost' (using
> password: YES) when trying to connect
>
>
> Got any idea what's wrong?

I think I once encountered a similar problem.

Did you try to remove the whitespace at the password statement and
enter your password directly?

Just turn "-p typo" into "-pyourpassword typo" and leave the rest as is.

This did the trick for me here...

HTH, Greets from Essen.

Dennis Wegner
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFEYbGAHcq0o4/FrD0RAtBWAJsGFYdhEEBl1vCagJzgicMmfpEKXACbBMaH
9EjfJA9+b982gT6nKHnaS1A=
=My3H
-----END PGP SIGNATURE-----
This topic is locked and can not be replied to.