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

How to install the graphical interface in Linux

1. Linux installation (root user operation) 1. In...

Based on JavaScript ES new features let and const keywords

Table of contents 1. let keyword 1.1 Basic Usage ...

Solution to win10 without Hyper-V

Are you still looking for a way to enable Hyper-v...

Solution to installing vim in docker container

Table of contents The beginning of the story Inst...

MySQL: Data Integrity

Data integrity is divided into: entity integrity,...

What you need to know about msyql transaction isolation

What is a transaction? A transaction is a logical...

Html sample code for reading and displaying pictures in a local folder

One purpose Select a local folder on the Html pag...

VMware Workstation 14 Pro installs CentOS 7.0

The specific method of installing CentOS 7.0 on V...

MySQL Server IO 100% Analysis and Optimization Solution

Preface During the stress test, if the most direc...

Several methods of calling js in a are sorted out and recommended for use

We often use click events in the a tag: 1. a href=...

Analyzing the four transaction isolation levels in MySQL through examples

Preface In database operations, in order to effec...

Linux virtual memory settings tutorial and practice

What is Virtual Memory? First, I will directly qu...