PHP MYSQL Linux has gradually become a classic combination of small web servers. Constructing and debugging the Mysql database in a Windows environment is a preferred choice for many web developers. I start school in the Windows98 environment, and I will summarize the learning process and experience to give you a reference.
1, download mysql-3.23.35-win.zip and decompressed;
2, run setup.exe; choose D: / mysql, "Tyical Install"
3, start mysql, have the following method:
Method 1: Use Winmysqladmin
1), enter the D :: / mysql / bin directory, run Winmysqladmin.exe, there will be a red icon in the right corner of the screen.
2), the mouse left click on the diagram, select "Show Me", appear "Winmysqladmin" operation interface; a dialog box will appear in the middle of the time, a dialog requires input and set your username and password
3) Select "My.ini Setup"
4) Select "MySQLD-OPT" or "MySQLD-NT" in "MySQLD file" (WINNT)
5), select "Pick-up or edit my.ini value" 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 use Winmysqladmin (automatically run when booting), select "Create Shortcut on Start Menu"
8), test:
Enter the DOS interface;
Run mysql in d: / mysql / bin directory, enter the MySQL interactive interface
Enter SHOW DATABASES and enter, the screen shows the currently available database MySQL and Test
Method 2: Do not use Winmysqladmin
1) Under the DOS window, enter the D: / mysql / bin directory
2), under Win9X) Run:
mysqld
Run under NT:
MySQLD-NT --STANDALONE
3), after this, MySQL runs in the background.
4) Test mysql: (in D: / MySQL / BIN directory)
a), mysqlshow is normal to display the existing two databases Mysql and Test
b), mysqlshow -u root mysql is normal to display five tables in database mysql:
Column_priv
DB
Host
TABLES_PRIV
User
c), mysqladmin version status proc display version number, status, process information, etc.
d), mysql test enters the MySQL operation interface, the current database is TEST
5), MySQL Close method: mysqladmin -u root shutdown
4. To this, MySQL has been successfully installed, followed by familiar with the common command of MySQL and creates its own database.
