C # + mysql software solution

A previous colleague asked me to create a customer management system for their company a few days ago. Requires 100,000 million data records. Provides the installation package for LAN usage. I designed it based on their requirements for the system. The software is not big, but the data is not small (I personally think, it is actually not big ). I didn't select ACCESS. I chose MySQL as the data server. Cause

A previous colleague asked me to create a customer management system for their company a few days ago. Requires 100,000 million data records. Provides the installation package for LAN usage. I designed it based on their requirements for the system. The software is not big, but the data is not small (I personally think, it is actually not big ). I didn't select ACCESS. I chose MySQL as the data server. Cause

A previous colleague asked me to create a customer management system for their company a few days ago. Requires 100,000 million data records. Provides the installation package for LAN usage.

I designed it based on their requirements for the system. The software is not big, but the data is not small (I personally think, it is actually not big ). I did not select ACCESS

I chose MySQL as the data server. The reason is that the installation of simple files is not as big as mssql. Performance is also acceptable. Language C # developed on vs2005

The first problem I encountered was: Connecting C # to mysql.

The. net class library does not seem to be directly connected to MySQL services. Olebc is not easy to use and has never had a deep understanding of it.

Later, I chose Mysql. Data. dll to reference this library in the project. The developed software is the same as connecting to mssql.

Note: When using this class library for development, you also need to install two supported software:

The database may be garbled.

Solution: Modify the mysql character set to GB2312 and then restart the service.

After the program development is complete

After installing the Mysql service on a machine

Just connect to other hosts.

By default, MySQL does not allow external hosts to be connected. In this case, you need:

Enable mysql Port

Execute authorization statement

// Activate permissions for other hosts on the LAN

GRANT permission ON database name. Table name TO user name @ host name identified by "password"
GRANT all ON *. * TO 'root' @ '%' identified by '123'

// Use the firewall to activate port 3306

Program Installation

// Configure the database address.

Okay.

You can use the program.