MySQL startup solution Summary

Source: Internet
Author: User

This article mainly describes the MySQL startup method. We all know that MySQL is often used in practical applications, so it is also of high concern, the following is a description of the specific solution. I hope it will help you in your future study.

I recently re-installed the MySQL database (the best combination of PHP and MySQL). However, I chose to manually start the database during installation. I also looked at other people's startup methods on the Internet, but they were not quite complete, in addition, most of them are post objects. After you organize and operate them, you can use the following methods:

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

The simplest method:

MySQL start Method 1: start the service

After installation, in the windows service options, select MySQL (the best combination with PHP), and double-click to start the service .... 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 of MySQL startup: Command Line Operation

Start-> Run-> cmd open the DOS window. In the window, enter net start MySQL (the best combination with PHP) to start MySQL (the best combination with PHP ).

MySQL startup 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.

MySQL startup Method 4: 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)

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), 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

The above content is an introduction to the MySQL startup method. I hope you will get something.

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.