MySQL startup method and actual operation steps

Source: Internet
Author: User

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:

 
 
  1. columns_priv   
  2. db   
  3. host   
  4. tables_priv   
  5. 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.