Solution to MySQL 8.0 cannot start 3534

Solution to MySQL 8.0 cannot start 3534

MySQL 8.0 service cannot be started

Recently encountered when starting the MySQL service in cmd :

MySQL service is starting
The MySQL service could not be started. The service did not report any errors. Please type NET HELPMSG 3534 for more help.

This is a web image, because the problem has been solved

or

When starting the mysql service in this computer-management-services and applications-services

There is a watermark, just read it

First, let’s explain the most important solution.

Just go find the error message yourself! Although the content on CSDN is very good, there are many reasons why MySQL errors occur. You need to find your own error information.

For example, I just started using MySQL.
If this problem occurs, find a solution on CSDN.
Then I tried many methods, but none of them could solve the problem.

(This took about three or four hours in total. I was originally learning JDBC, which was very demanding on the patience of a beginner.)

Later, I saw a file with the suffix **.err**, and in this file I saw the [error] code.
(I didn't really care about it, but suddenly I found an error message in it)

Suffix .err

This is the specific error code of my problem

Try to translate it later to find the problem

Unknown suffix ' ' used for variable 'port' (value '3306 default-character-set=utf8 [WinMySQLAdmin] Server=D:\MySQL\bin\mysqld.exe').

Unknown suffix "" for variable "port" (value "3306 default character set=utf

I found that there was a problem with my my.ini file


The code above the picture is correct. The code below is wrong. This [WinMySQLAdmin] Server=D:\MySQL\bin\mysqld.exe
That is the Unknown suffix in the error.

Then modify the my.ini file and run cmd with administrator privileges
Enter the MySQL\bin directory and run net start mysql

Tears in my eyes!

To sum up, beginners must learn to use error codes to find specific errors.
Don't try to imitate others blindly, because things on the Internet are time-sensitive and may no longer be useful after a while.
At the same time, we also need to consider issues such as versions, as there are many influencing factors.

This is the end of this article about the solution to MySQL 8.0 cannot start 3534. For more related content about MySQL 8.0 cannot start 3534, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • MySQL 5.7.9 service cannot be started - solution for "NET HELPMSG 3534"
  • MySQL 5.7.14 net start mysql service cannot be started - strange problem of "NET HELPMSG 3534"

<<:  Incomplete solution for using input type=text value=str

>>:  Who is a User Experience Designer?

Recommend

IE8 provides a good experience: Activities

Today I had a sneak peek at IE8 beta 1 (hereafter...

javascript countdown prompt box

This article example shares the specific code of ...

HTML input box optimization to improve user experience and ease of use

In order to improve user experience and ease of us...

JavaScript to achieve the idea of ​​​​snake game

The implementation idea of ​​the javascript game ...

SQL Optimization Tutorial: IN and RANGE Queries

Preface "High Performance MySQL" mentio...

A brief discussion on the implementation principle of Vue slot

Table of contents 1. Sample code 2. See the essen...

Use nginx to configure domain name-based virtual hosts

1. What is a virtual host? Virtual hosts use spec...

About the usage and precautions of promise in javascript (recommended)

1. Promise description Promise is a standard buil...

HTML unordered list bullet points using images CSS writing

Create an HTML page with an unordered list of at l...

CentOS 6.4 MySQL 5.7.18 installation and configuration method graphic tutorial

The specific steps of installing mysql5.7.18 unde...

Several ways of running in the background of Linux (summary)

1. nohup Run the program in a way that ignores th...