Linux Server

database.md

Login MySQL

mysql -u root -p

Create User

CREATE USER 'username'@'%' IDENTIFIED BY 'password'

Cấp quyền

GRANT ALL PRIVILEGES ON main.* TO username@'%';

or

GRANT ALL PRIVILEGES ON main.* TO username@'%' IDENTIFIED BY 'password';

Backup

mysqldump db_name > backup-db_name.sql
mysqldump -u userNameHere db_name > backup-db_name.sql
mysqldump -u userNameHere -p db_name > backup-db_name.sql

Restore

mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file-name.sql}
mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {backup.db.file-name.sql}
mysql -e "source /path/to/backup-db.sql" db_name_here
mysql -u DB_USER_NAME -p -e "source /path/to/backup-db.sql" db_name_here