Installation article
PHP MySQL Linux is now becoming a classic combination of small Web servers. Building and debugging MySQL databases in a indows environment is a top choice for many Web developers. I Windows98 in the environment to learn MySQL, now the learning process and experience summed up for your reference.
1, download mysql-3.23.35-win.zip and decompression;
2, run setup.exe; Select D:mysql, "tyical Install"
3, start MySQL, there are the following methods:
Method One: Use Winmysqladmin
1), enter the D::mysqlin directory, run Winmysqladmin.exe, in the lower right corner of the screen will have a red symbol in the taskbar
2), the left mouse button click on the symbol, select "Show Me", the "Winmysqladmin" interface appears; a dialog box will appear in the middle of the first run to require you to enter and set your user name and password
3), select "My.ini Setup"
4), select "Mysqld-opt" (Win9x) or "Mysqld-nt" (WinNT) in "Mysqld file"
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 the Winmysqladmin (automatically run when the boot), select "Create ShortCut on Start menu"
8), test:
Enter the DOS interface;
Run MySQL in the D:mysqlin directory and enter the MySQL interactive interface
Enter show databases and return to the screen showing the current two databases MySQL and test
Method Two: Do not use Winmysqladmin
1), Under DOS window, enter the D:/mysql/bin directory
2), Win9x) operation:
Mysqld
Run under NT:
Mysqld-nt--standalone
3), after that, MySQL runs in the background
4), test MySQL: (under the D:/mysql/bin directory)
a), mysqlshow
Normal display of existing two databases MySQL and test
b), mysqlshow-u root MySQL
Normal displays five tables in MySQL database:
Columns_priv
Db
Host
Tables_priv
User
c), mysqladmin version status proc
Display version number, status, process information, etc.
d), MySQL test
Into the MySQL interface, the current database is test
5), MySQL shutdown method:
Mysqladmin-u Root shutdown
4. At this point, MySQL has been successfully installed, and then you can familiarize yourself with the common MySQL commands and create your own database.
http://www.bkjia.com/PHPjc/631023.html www.bkjia.com true http://www.bkjia.com/PHPjc/631023.html techarticle installing PHP MySQL Linux is now becoming a classic combination of small Web servers. Building and debugging MySQL databases in a indows environment is a top choice for many Web developers. I ...
