Attempting to start service MySQL5.7 during installation

Source: Internet
Author: User

Attempting to start service MySQL5.7 during installation.

1, the mechanism opens the service and starts the MySQL service name (my is Mysqlaliyun)

Startup failure: Prompt for 1067 error.

2, copy My-default.ini as My.ini under the MySQL installation directory (C:\Program files\mysql\mysql Server 5.7)


Uncomment the Basedir and DataDir in My.ini:
#设置basedir指向mysql的安装路径
basedir= C:\Program files\mysql\mysql Server 5.7
datadir= C:\Program files\mysql\mysql Server 5.7\data

Copy the My.ini to the c:/windows.

Restart ...
CODE:
C:\Program files\mysql\mysql Server 5.7\bin>net start mysql57
The MySQL service is starting.
The MySQL service could not be started.
System error.
System error 1067 has occurred.
The process terminated unexpectedly.

Registry cleanup:
Find the keyword "MySQL" and then perform the delete operation
Windows Firewall Port cleanup
Delete all MYSQ ports or programs in the firewall

C:\Program files\mysql\mysql Server 5.7\bin>mysqld–remove Mysqlaliyun
Service successfully removed.
C:\Program files\mysql\mysql Server 5.7\bin>mysqld–install MySQL57
Changed a service name, replaced it with a mysql57

Service successfully installed.


C:\Program files\mysql\mysql Server 5.7\bin>net start mysql57
The MySQL service is starting.
The MySQL service has started successfully.

C:\Program files\mysql\mysql Server 5.7\bin>net Stop mysql57
The MySQL service is stopping:
The MySQL service has stopped successfully.

Attempting to start service MySQL5.7 during installation

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.