RE: my.cnf authencication
- Date: Fri, 29 Jan 2016 15:15:43 +0100
- From: "Harrie Robins" <harrie@xxxxxxxxxxxxxx>
- Subject: RE: my.cnf authencication
Thanks for the reply - that was indeed a typo. I resolved this buy making these changes:
mysqldump --defaults-extra-file="c:\sql\dump.cnf" dname > c:\loc
with my cnf containing:
user = user
password = pass
Looks like I misplaced "" and or [client] / [mysqldump] in the cnf
From: Johan De Meersman [mailto:vegivamp@xxxxxxxxx]
Sent: vrijdag 29 januari 2016 15:06
To: Harrie Robins <harrie@xxxxxxxxxxxxxx>
Cc: MySql <mysql@xxxxxxxxxxxxxxx>
Subject: Re: my.cnf authencication
----- Original Message -----
> From: "Harrie Robins" <harrie@xxxxxxxxxxxxxx>
> Subject: my.cnf authencication
> mysqldump --defaults-file dbase > c:\sql\dbase.sql 2>> c:\log.tct
Might just be a typo in your mail, but you'll need to actually pass the defaults-file, too: --defaults-file=c:\sql\dump.cnf .
I think there may be another typo somewhere, too, as it seems to think that lts-file is the user you're passing. I'm wondering if you haven't accidentally put only a single - in front of defaults-file.
> My log shows:
> mysqldump: Got error: 1045: Access denied for user
> 'lts-file=c:\sql\dump.cnf'@'localhost' (using password: NO) when
> trying to connect
> It looks like credentials are not filled in!?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
Unhappiness is discouraged and will be corrected with kitten pictures.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql