Installing MySQL Databases in Windows is not difficult

The following articles mainly describe how to install MySQL Databases in Windows. We all know that installing MySQL is not an easy task, however, if you have some knowledge about the actual installation steps, you can easily install the MySQL database in the PWindows environment.

PHP + MySQL (the best combination with HP) + Linux has gradually become a classic combination of small web servers. Building and debugging MySQL (the best combination with PHP) databases in the indows environment is a preferred choice for many website developers. I am a beginner in MySQL in Windows 98 (the best combination of PHP and MySQL). I will summarize the learning process and experience for your reference.

1. Download and decompress mysql(and PHP combination --3.23.35-win.zip;

2. Run setup.exe; select d: \ MySQL (the best combination with PHP) and "tyical install"

3. Start MySQL (the best combination with PHP) by using the following methods:

Method 1: Use winMySQL (the best combination with PHP) admin

1) go to the d: \ MySQL (the best combination with PHP) \ bindirectory and run the "cmdadmin.exe" combination of winmysql(and PHP. A red icon is displayed in the taskbar in the lower right corner of the screen.

2) Click the icon and select "show me". The "WinMySQL (best combination with PHP) Admin" operation interface is displayed; during the first running, a dialog box appears asking you to enter and set your username and password.

3) Select "My. INI setup"

4) In "MySQL (the best combination with PHP) d file", select "MySQL (the best combination with PHP) d-opt" (win9x) or "Install MySQL (the best combination with PHP) d-nt" (winNT)

5) Select "Pick-up or Edit my. ini values" to Edit your my. ini file in the right window.

6) select Save Modification to Save your my. ini file.

7) If you want to quickly use winMySQL (the best combination with PHP) admin (which runs automatically upon startup), select "Create ShortCut on Start Menu"

8) test:

Enter the DOS interface;

Run and install MySQL in the d: \ MySQL (the best combination with PHP) \ bin directory (the best combination with PHP) to enter MySQL (the best combination with PHP) interactive Operation Interface

Enter show databases and press Enter. The current two databases MySQL (the best combination with PHP) and test are displayed.

Method 2: Do not use winMySQL (the best combination with PHP) admin

1) in the DOS window, enter the d:/MySQL (best combination with PHP)/bin directory.

2) run in win9X:

MySQL (best combination with PHP) d

Run in NT:

MySQL (best combination with PHP) d-nt -- standalone

3) since then, MySQL (the best combination with PHP) will run in the background

4) test MySQL (the best combination with PHP): In the d:/MySQL (the best combination with PHP)/bin directory)

A), MySQL (the best combination with PHP) show

Normally, the existing two databases MySQL (the best combination with PHP) and test are displayed.

B), MySQL (the best combination with PHP) show-u root MySQL (the best combination with PHP)

When the database is installed normally, the following five tables are displayed in the best combination of MySQL and PHP:

Columns_priv

Db

Host

Tables_priv

User

C), MySQL (the best combination with PHP) admin version status proc

Displays the version number, status, and process information.

D), MySQL (the best combination with PHP) test

Go to the MySQL (best combination with PHP) operation interface. The current database is test.

5), MySQL (the best combination with PHP) Close method:

MySQL (best combination with PHP) admin-u root shutdown

4. Now, MySQL (the best combination of PHP and MySQL) has been successfully installed, and you can familiarize yourself with Common commands of MySQL (the best combination of PHP and MySQL) and create your own database.