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

MySQL Basics Quick Start Knowledge Summary (with Mind Map)

Table of contents Preface 1. Basic knowledge of d...

Solve the cross-domain problem of get and post requests of vue $http

Vue $http get and post request cross-domain probl...

js to realize a simple advertising window

This article shares the specific code of js to im...

Use pure CSS to achieve switch effect

First is the idea We use the <input type="...

Detailed tutorial on deploying Hadoop cluster using Docker

Recently, I want to build a hadoop test cluster i...

An article teaches you to write clean JavaScript code

Table of contents 1. Variables Use meaningful nam...

Docker sets up port mapping, but cannot access the solution

#docker ps check, all ports are mapped CONTAINER ...

CSS3 clear float method example

1. Purpose Through this article, everyone can und...

Display flex arrangement in CSS (layout tool)

Regarding display: flex layout, some people have ...

HTML+CSS+jQuery imitates the search hot list tab effect with screenshots

Copy code The code is as follows: <!DOCTYPE ht...