[Database] Release and installation of MySQL

MySQLInstructions for use

 

 

 

 

 

We have encountered many problems in using MySQL. This article describes the classic usage of MySQL.

MySQL is a typical network database that can be used on Linux and Windows platforms and is free of charge. Currently, MySQL provides a good interface for maintenance. In Windows, the maintenance of MySQL is similar to that of MSSQLServer, and can be used by non-database professionals.

However, MySQL is still not complete in some maintenance tools. For example, sqlserver provides its own proxy service to perform routine automatic database backup, while MySQL does not have similar services.

 

 

 

 

 

In typical cases, MySQL has two forms: Binary release and source code release. We mainly use binary MySQL release on the Win2000/xp platform. There is a dedicated installation program for Binary release. We can install it as per Steps. After installation, it is generally run as a winnt service. In addition, the maintenance tool must be installed separately, and the installation process is simple.

 

 

 

 

 

In many cases, the usage of computers is uneven. If our products require users to install their own database management systems and configure the database based on the specific computer performance, the difficulty of using our software is greatly increased. MySQL provides release without installation. We can package the database system directly into our software package and install the database system while installing our software, then, a simple Database Configuration tool is allowed. For example, you can only select the computer configuration (high, medium, and low. During installation, the MySQL database system is automatically configured. The following describes the specific operation process.

 

 

 

 

 

1. Package the standard MySQL package and the MySQL Maintenance Toolkit when packaging our program, but there is no shortcut to the maintenance tool, in this way, the primary users will not have database misoperations, and the retention of these packages is for our maintenance personnel to better carry out system maintenance.

2. The specific package is as follows:

Mysql-MySQL services and clients, about 33 m;

Mysqlguitools-MySQL service maintenance interface, about 8 m;

Mysql-MySQL console interface, about 6.62 m;

47.62 MB in total;

The above packages can be obtained from the Internet.

3. The package is larger. We can provide users with a CD or download the program on our website.

4. There are large, medium, and small system configuration files in the MySQL package. Select the files based on your computer performance and copy the files to your Windows Directory during configuration. For example, if we want to configure a small system, you can copy the my-small.ini to C:/WINNT and rename it my. ini.

If it is not installed on drive C by default, modify basedir and datadir as follows:

[Mysqld]

# Set basedir to your installation path

Basedir = E:/MySQL

# Set datadir to the location of your data directory

Datadir = E:/mydata/Data

 

 

 

 

 

5. Install the service.

After windows is installed, MySQL is not installed as a service. You must run the following statement to register MYSQL as a service: installdir/MySQL/bin/mysqld-NT -- install.

There is no service concept in Windows 98, so you do not need to install the service.

6. Start the service

In Windows2000, you can start the MySQL service: Net start MySQL after installing the service.

In Windows 98, run the following command to start the service: C:/MySQL/bin/mysqld. After the service is started, it runs in the background and has no interface.

7. Stop the service

In Windows2000, run the following command to stop the MySQL service: net stop MySQL.

In Windows 98, run the following command to stop the service: C:/> C:/MySQL/bin/mysqladmin-u root shutdown:

8. Uninstall the service

Run the following command to uninstall the MySQL service: installdir/MySQL/bin/mysqld-NT -- remove.

After the above installation, we can use it. You can build a database that is empty in our system into the MySQL data directory. The default database directory is installdir/MySQL/data.

You can use the dbexpress component to access the MySQL database. The dbexpress component is a group of efficient database access components. If you change the connection string, you can directly connect the data source to databases such as MSSQLServer.

 

 

 

 

 

 

 

 

 

 

The preceding section only provides common installation and configuration. For more information, see the documents provided by MySQL.