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
我爱mysql
发表评论
800 views