MySQL Create user and backup

MySQL create user and authorize

Authorized user Grant Grant all permissions specify Source IP
Grant All on .(so the table) to ' user1 ' @ ' 1.1.1.1 ' (% pass with so IP) identified by ' 123456a '

Login Verification

Error default use of authorization is souck plus-h

Authorizing local use of locahost links

Verify Login

Specify a specific permission-specific table
User Rights Query

Common SQL statements

View the number of rows in a table

View the contents of a table
SELECT * FROM mysql.db very resource-intensive
The engine of the database
MyISAM
Use MySQL
Show CREATE TABLE user\g default engine automatic statistics row

InnoDB y engine does not count rows
Use db1e
Show creat datable t1

Query two fields of a table

Insert

Change

Delete Deletes

Clear table

Drop Delete Table

Delete database drop databases

MySQL Database backup recovery

Backup MySQL Library

Recovery Library

Backup table
! []
Recovery table

Back Up all libraries

Back up the table structure only the data of the table

Concept
A transaction (Transaction) is a program execution unit (unit) that accesses and possibly updates various data items in a database. Transactions are typically caused by the execution of user programs written by advanced database manipulation languages or programming languages (such as sql,c++ or Java) and are defined with the form of the BEGIN TRANSACTION and end Transaction statements (or function calls). A transaction consists of all operations performed between the start of a transaction (BEGIN TRANSACTION) and the end of the transaction (end transaction).
For example: In a relational database, a transaction can be an SQL statement, a set of SQL statements, or an entire program.
Characteristics
Transactions are the basic unit of recovery and concurrency control.
A transaction should have 4 properties: atomicity, consistency, isolation, and durability. These four properties are often called acid properties.
Atomicity (atomicity). A transaction is an inseparable unit of work, and the operations included in the transaction are either done or not.
Consistency (consistency). The transaction must be to change the database from one consistency state to another. Consistency is closely related to atomicity.
Isolation (Isolation). Execution of one transaction cannot be disturbed by other transactions. That is, the operations inside a transaction and the data used are isolated from other transactions that are concurrently executing, and cannot interfere with each other concurrently.
Persistence (durability). Persistence, also known as permanence (permanence), refers to the fact that once a transaction is committed, its changes to the data in the database should be permanent. The next operation or failure should not have any effect on it.

MySQL Create user and backup