notes/article/mysql/backup.md

Mysql Config

Backup and recover

Backup

Backup all databases schema with data:

mysqldump -uroot -p123456 -h localhost -P 3306 --all-databases --default-character-set=utf8 --single-transaction > all.sql

Bakcup specified database

Restore Databases

mysql -uroot -p123456 < all.sql

User Config

Creation

create user 'work'@'%' identified by '123456';

Grant privileges

grant all on *.* to 'work'@'%';