Connection configuration issues between mysql and Navicat for MySQL

First change the php configuration file:

There are two main places here:
Cirl + F to find mysql.dll

Then remove the ";" in front

Then modify the path:
Cirl + F to find extension_dir

Then change the following path, which varies from person to person. The final path is changed to the php installation path/ext

For example: the blogger's php installation path is: F:wwwseverphp-5.3.4

Then:

Regarding the registration code issue of Navicat for MySQL software, the blogger provides a registration machine here, which is the blogger’s Baidu Cloud address:

http://pan.baidu.com/s/1i5NJyHv

You can download it from here After downloading the registration machine, install it according to the instructions.

Generally, after the installation is completed, click Help->About... If there are no three words "unactivated" under your registration code, it means that you have obtained permanent use rights.

The next step is to import the code:
The file given by the teacher is of sql type, so it cannot be imported directly (this statement is invalid). Navicat for MySQL software is used here:
The specific method is:

Tools-"Command Line Interface

This An interface similar to the command line will appear

Create a database in this interface:

create database database name

GO

use database name

GO

Method 1. Right-click the created database name on the left , and then click "Run SQL File"

Method 2, copy the teacher's code

Enter

Refresh the left side and you will see the newly generated table

The specific code for the previous class assignment is in another blog post. , omitted here.

The above introduces the connection configuration issues between mysql and Navicat for MySQL, including the content of navicat for mysql. I hope it will be helpful to friends who are interested in PHP tutorials.