grant all on *.* to user@'1.1.1.1' identified by 'ZTZLlm';
grant all on db_name.* to user@'1.1.1.1' identified by 'e06AZr';

create user user@'127.0.0.1' identified by 'xxxxx';
grant all on *.* to user@'127.0.0.1';
grant select on *.* to user@'127.0.0.1';

mysqldump -R -E -uuser -p123456  --default-character-set=utf8 db_name > db_name.bak
mysql -uuser -p123456 --default-character-set=utf8 -vvv -c db_name < test.sql > test.log 2>&1

mysqldump -uuser -p12345 -R -E --default-character-set=utf8mb4 --set-gtid-purged=OFF db_name > db_name.bak
mysql -uuser -p12345 --default-character-set=utf8mb4 -vvv -c db_name   < 1.sql   > 1.log

#查询MYSQl数据表中的最后一条记录
select * from table order by id DESC limit 1