Mysql data backup and recovery, User Creation, authorization, mysql backup and recovery

Mysql data backup and recovery, User Creation, authorization, mysql backup and recovery

Mysql data backup and recovery, User Creation, authorization

1. Mysqldump> outfile. SQL

2. Mysql-uxxx-pxxx <backfile. SQL

3. Create user 'username' @ 'host' identified by 'Password'

4. Grant all privileges on DBNAME. * to 'username' @ 'host' // Add permissions. Pay special attention to the * number after DBNAME.

5. revoke all privileges on DBNAME. * to. * 'username' @ 'host' // cancel the permission. Pay attention to the * number after DBNAME.

6. Mysql's storage engine type directly affects the utility of constraints (for example, foreign key constraints are useless in MyISM and are useful in InnoDB)

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.