MySQL Basic usage

Recent projects use MySQL database and have not been contacted before. So I found some information to study.

The basic MySQL data operation is currently done through the Navicat for MySQL tool.

1. After installing navicat for MySQL, establish the connection.

2. Import the SQL statement that you want to create. Load the SQL statement you want to import by selecting the library name and right-running the SQL file.

3. Add the data, note the added field if you increase the hint 1306 error, you need to modify the field's sign bit UTF8 to increase

4. If you are connecting to a MySQL server remotely, you need to authorize client access in the remote server MySQL

Grant all privileges the test.* to ' userid ' @ Client IP address identified by ' Password with GRANT OPTION;

FLUSH privileges; --IP Client

You can access the MySQL database by running the above statement.