Recently, I have re-installed the MySQL database (the best combination with PHP). However, I chose to manually start MySQL and learn from other people's startup methods on the relevant Internet, unfortunately, the installation steps are not complete, and most of them are post. After finishing and operating, you can start MySQL (the best combination with PHP) by using the following methods:
The simplest method:
Method 1: start the service
After installation, in the windows service options, select MySQL (the best combination with PHP), and double-click MySQL to start .... Right-click my computer and choose manage> Computer Management. Choose services and applications> services> MySQL (the best combination of PHP and MySQL) 4-> double-click to start .)
Method 2: command line operations
Start-> Run-> cmd open the DOS window. In the window, enter net start MySQL (the best combination with PHP), that is, MySQL starts MySQL (the best combination with PHP ).
Method 3: 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 "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 MySQL (the best combination with PHP) in the d: \ MySQL (the best combination with PHP) \ bin directory 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 4: Do not start with 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)
Normally, the following five tables are displayed in the MySQL database (the best combination of PHP and MySQL:
- 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) Start 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