mysql 重要指令

https://github.com/sqonk/mysql-sync

https://github.com/mrjgreen/db-sync

mysqldump -uroot -p2gaujrgr –max_allowed_packet=1024M  –databases –single-transaction csr  | gzip > /usb_4t/mysql_dump/2021-11-22-20/csr.gz


設定權限
GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

#1364 – Field 'ssl_cipher' doesn't have a default value
要去修改 my.cnf
增加
sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION