MySQL user management, common SQL statements, and database backup

One, MySQL user management

1. Create user (user root, highest privilege)
Grant all on . to ' user1 ' @ ' localhost ' identified by ' passwd ';
(The MySQL file specifies the socket)

Grant all on the user1 ' @ ' 127.0.0.1 ' identified by ' passwd ';
(Specify-H when MySQL configuration file specifies IP)

Description: Grant all//Authorize all permissions,
@ ' localhost '//Specify the source IP, if you change it to%, it means all IP, wildcard
. The first one refers to the library name, . * Is all
2. Authorized users

II. Common SQL statements Third, MySQL database backup recovery iv. INNOBACKEX tools backup MySQL Data

Xtrbackup can only be used to back up the database of the InnoDB engine, and Innobackex either backs up the database for the InnoDB engine or backs up the MyISAM engine's database. Backup can also be divided into full-scale backup and incremental backup
1. Install Yum extension source Percona-release

RPM-IVH http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

2, Installation Percona-xtrabackup

Yum Install Percona-xtrabackup

MySQL user management, common SQL statements, and database backup