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:

[client]
user = user
password = pass

Looks like I misplaced "" and or [client] / [mysqldump] in the cnf

Thanks



-----Original Message-----
From: Johan De Meersman [mailto:[email protected]] 
Sent: vrijdag 29 januari 2016 15:06
To: Harrie Robins <[email protected]>
Cc: MySql <[email protected]>
Subject: Re: my.cnf authencication

----- Original Message -----
> From: "Harrie Robins" <[email protected]>
> 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!?
> 
> Regards,
> 
> 
> 
> --
> 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