How to register the MySQL service after WIN7 reload system

Source: Internet
Author: User

in fact, if you do not format the MySQL disk when you reload the system, our MySQL does not need to be re-installed
Operation:
1. Create a MySQL service:
start-up and run the-->cmd CD command into the MySQL bin directory (e.g. D:\mysql\bin)
mysqld--install here to fill in the MySQL service name (such as: MySQL)--defaults-file= "here to fill in the path of My.ini (such as: D:\mysql\my.ini)", if successful will be displayed: Service Successfully installed
2. Start the service net start here to write the MySQL service name (for example: MySQL)
stop service net stop MySQL service name

PS:
a)This operation is critical in the 1th step, the path of the My.ini must be written in double quotation marks, otherwise the creation will fail, and the CD command must be in the bin directory or you will be prompted to "cannot find the specified file" error when starting the MySQL service  
b) If you have forgotten your MySQL password, you can log in and change your password by logging in with MySQL without password .
c) To delete an existing MySQL service, mysqld--remove mysql service name

How to register the MySQL service after WIN7 reload system

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.