今天在公司进行版本升级,进行mysql备份时(5.6),遇到了如下问题:
mysqldump
mysqldump -uUSER -p DATABASE > /dump/sqldata/xxxdata_`date +%F`_bak.sql
Enter password:
mysqldump: Got error: 1045: Access denied for user 'USER'@'localhost' (using password: YES) when using LOCK TABLES
mysqldump有一些默认为True的选项
mysqldump --help | grep -i true
and boolean options {FALSE|TRUE} Value (after reading options)
add-drop-table TRUE
add-locks TRUE
comments TRUE
create-options TRUE
disable-keys TRUE
extended-insert TRUE
lock-tables TRUE
quick TRUE
quote-names TRUE
set-charset TRUE
dump-date TRUE
secure-auth TRUE
triggers