Mysql entry Series: install MySQL_MySQL on Windows

Mysql entry Series: you can install MySQL on Windows and run MySQL on Windows 95, Windows 98, or Windows NT. To do this, you must install the TCP/IP support environment, and the Winsock Software must be at least version 2.

You can install two types of software in Windows:

? Independent programs, such as those installed for UNIX (mysqld server and programs such as m s y q l and mysladmin ).

? M y ODBC: the MySQL driver that allows other programs (such as A c e s) to communicate with the MySQL server.

All Windows distribution packages can be obtained from the MySQL site as zip files. To open such a file, you just need to double-click it. If this is not the case, you can use a program such as Winzip or pkunzip to open it. Main distribution package:

? Mysqlw I n. ver s I o n. zip full distribution package (server and client ).

? W I n c l I e n t s-ver s I o n. z I p client software (mysql, mysqla d m I n, mysqldump, etc ). If you do not want to run the server in Windows, you can use this software.

? My o db c-ver s I o n-w I n 9 5. z I p

My o db c-ver s I o n-n t. z I p

Windows 95 (Windows 98) or Windows NT MyODBC support environment.

? Mysqlc l I e n t-ver s I o n-c y g w I n-B 2 0. t a r.gz MySQL client compiled using the Cygnus tool set. It includes mysqlc, a mysql client version with the command line history editing function. To install it, copy the library cygwinb19.dll from c: mysqllib to the Windows system directory.

Install client-only distribution packages or client/server distribution packages

If you have a winclients.version.zip distribution package containing only the client software, unbind it to generate a mysql folder. Locate this folder to c :.

If you have a mysqlwin-version.zip distribution package containing the server and the client, open it first. In the result folder, run the Setup program and install mysql in c: MySQL.

Select from the following servers: server description
Mysqld standard server
Mysqld-opt is a Pentium processor optimized server.
Mysqld-nt can be used as a server installed under Windows NT.

You can run any server under NT, but the last one can only run under NT.

To run mysqld or mysqld-o p t, start the server as follows:

C:> c: mysqlinmysqld

C:> c: mysqlinmysqld-opt

To disable this server, you can use the mysqladmin utility:

C:> c: mysqlinmysqladmin-uroot shutdown

In Windows NT, you can run mysqld-nt as a service:

C:> c: mysqlinmysqld-nt -- install

If you start mysqld-n t in this way, you can specify the options by placing them in the option file C: my. cnf. You cannot specify these parameters on the command line. When mysqld-nt is running as a service, you can use the following command to start or stop it:

C:> net start mysql c:> net stop mysql you can use the Services control Manager utility in the Control Panel folder to start and stop the server, or use the mysqladmin utility from the command line to stop the server: