Mysql basic usage _ MySQL

Basic usage of mysql recently used the mysql database in the project, which has never been used before. So I found some materials to learn.

Currently, basic mysql data operations are performed using the navicat for mysql tool.

1. after navicat for mysql is installed, establish a connection.

2. import the SQL statement to be created. Right-click the database name to run the SQL file and load the SQL statement to be imported.

3. add the data. Note that if the error 1306 is displayed when the added field is added, you need to modify the symbol bit utf8 of the field to add it.

4. if you remotely connect to the mysql server, you need to authorize the client access statement in the remote server mysql.

Grant all privileges on test. * TO 'userid' @ client IP address identified by 'password with grant option;

Flush privileges; -- ip client

Run the preceding statement to Access the mysql database.