MySQL Basic use method

Recent projects using MySQL database, have not been contacted.

So I found some information to study.

The basic MySQL data operation is now done through the navicat for MySQL tool.

1. After installing Navicat for MySQL. Establish the connection.

2. Import the SQL statement that you need to create. Execute the SQL file by selecting the library name right-click. Load the SQL statement that you need to import.

3. Add the data, and note that the added field assumes the added hint 1306 error. You need to change the field's sign bit UTF8 to add

4. Assume that the remote connection is MySQLServer. Authorization statements for client access are required in remote Servermysql

GRANT all privileges on test.* to ' userid ' @clientIP address identified by ' Password with GRANT OPTION;

FLUSH privileges; --ipclient

Execute the above statement to access the MySQL database.

MySQL Basic use method