Mysql instructions
We met many problems in MySQL, this article gives Mysql classic use.
MySQL is a typical network database, which can be applied to the Linux platform and Windows platform and free. Now MySQL also provides a good interface for maintenance, making the maintenance of mysql and the maintenance of MSSQLServer, can also be used by non-database professionals under Windows.
However, MySQL still has no SQL Server in some maintenance tools, such as SQL Server to provide proxy services, can make daily automatic database backup, and MySQL has no similar service.
Typically, mysql has two forms of binary release and source code, which mainly uses binary MySQL under Win2000 / XP platform. The binary release has a dedicated installer, we can install it by step. The service is generally running as a Winnt service after installation. An additional maintenance tool is also installed, and the installation process is very simple.
Many situations, our faculty is uniform to the computer's use. If our products require users to install the database management system themselves, and to configure the database according to the specific computer performance, it will increase our software difficulties. And MySQL provides issues that do not need to be installed, we can pack the database system directly into our package, install the database system while installing our software, then allowing a simple database configuration tool, such as only allowing users to choose Computer configuration (high, medium, low) can be. We automatically configure the MySQL database system while installing, and below is the specific operation process.
1. Package the standard published mysql package, MySQL maintenance kit, but may not produce shortcuts in maintenance tools, so that primary users do not have database misunderstand; but retain these packages It is for our maintenance personnel to make system maintenance.
2, the specific package is as follows:
MySQL - MySQL service and client, about 33m;
Mysqlguitools - MySQL service maintenance interface, about 8m;
MySQLCC - MySQL's console interface, about 6.62m;
A total of 47.62m;
The above packages can be obtained from the Internet.
3, the package is big, we can provide the user with the disc, or put the program on our website to download.
4. There is a large, medium and small system profile in the MySQL package. According to the user's computer performance, copy the corresponding file to the user's Windows directory when configured. Such as: If we want to configure a small system, you can copy the My-Small.ini to C: / Winnt and then renamed My.ini.
If it is not the default installation in the C drive, pay attention to modifying 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.
Under Windows 2000, after the installation is complete, there is no mysql to be installed, and we must perform the following statements to register mySQL as a service: installdir / mysql / bin / mysqld-nt --install.
There is no service concept under Windows 98, so you don't have to install the service.
6, start service
Under Windows2000, you can start the MySQL service after installing the service: Net Start MySQL.
Under Windows 98, you can start the service with the following command: c: / mysql / bin / mysqld, after the service is started, running in the background, there is no interface.
7, stop service
Under Windows 2000, you can stop MySQL service by the following command: NET STOP MySQL.
Under Windows 98, you can stop using the following command: C: /> C: / mysql / bin / mysqladmin -u root shutdown
8, uninstall service
You can uninstall the mysql service by the following command: installdir / mysql / bin / mysqld-nt --remove.
You can use it through the above installation, you can build our system empty database to the mysql data directory, the default database directory is in InstallDir / MySQL / DATA.
Accessing the MySQL database can pass the DBEXPRESS component, the DBEXPRESS component is a set of efficient database access components. As long as you change the connection string, we can connect the data source directly to the MSSQLServer and other databases.
The above is only provided for common installation and configuration, please refer to Mysql self-contained document if you need more information.
