Correct answers to MySQL service failure

Source: Internet
Author: User

The following articles mainly describe the correct solution that MySQL service cannot start in actual operations. If you encounter similar situations in actual operations, however, you do not know how to solve the problem correctly, so the following articles must be good teachers and friends for you.

The installation of mysqland winmysqladmin.exe cannot be started. When the MySQL service is started in the management tool service, an error is reported midway through. The content is: MySQL service cannot be started on the local computer. Error 1067: the process is aborted unexpectedly.
Cause: the my. ini file is not found. This file should be in the C: \ Windows directory.

Solution: Find the my. ini file in the System Directory, which may be C: \ Winnt or C: \ windows. If the file does not exist, create a new one.) Add the following content.
The my. ini file can be found in the C: \ Documents ents and Settings \ lbq \ WINDOWS directory, but cannot be found in the system directory. After copying it, you can.

 
 
  1. [mysqld]  
  2. # set basedir to installation path, e.g., c:/mysql  
  3. basedir=D:/www/MySQL  
  4. # set datadir to location of data directory,  
  5. # e.g., c:/mysql/data or d:/mydata/data  
  6. datadir=D:/www/MySQL/data  

This is done.

The above content is an introduction to the solutions that cannot be started for MySQL services. I hope you will find some gains.

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.