MySQL database installation (original)

1, first download the MySQL database, I installed the mysql5.1 version, directly installed on the line, but if you want to display in the database in Chinese, you want to set the character set to gb2312

2. Configure Data source ODBC. Mysql-connector-odbc-3.51.20-win32.exe (This is the MySQL data source DOBC installer), configuring the ODBC process can refer to http://jingyan.baidu.com/article/ 8065f87f38b31423312498e4.html

3, install the MySQL management tool, Navicat for MySQL, to connect to the database after opening Navicat, in the following way: Create a new connection in Navicat, fill in the general settings, if you are accessing the local database, the hostname or IP address can be filled in: localhost or 127.0.0.1 sometimes only fill one of them so that the other is not so, (I did not study here carefully) attention! Navicat for MySQL database connection before you open the MySQL database (service) ....

4. The MySQL database can be connected in the new connection in Navicat.

5, can now import the external database table, or set up a table, here to talk about the author in the import of external tables encountered problems, the first is the problem of character encoding, In the process of MySQL installation Although the character encoding is set to gb2312 but in the Navicat with Chinese data table table (such as Excel table) can not be imported into the Navicat database table, That is because although the character encoding is set in MySQL, but in the Navicat character encoding is not set to gb2312, you need to right-click the database in Navicat, select the database properties to set the character encoding inside the gb2312 side can!

6, as to the import table can right-click the table in the Database Selection Import Wizard, easy to operate, the issue of export is not described here.

7. So far, the data has been built.

MySQL database installation (original)