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

Detailed explanation of MySQL execution plan

The EXPLAIN statement provides information about ...

Detailed explanation of how to enable slow query log in MySQL database

The database enables slow query logs Modify the c...

Example of using CSS to achieve semi-transparent background and opaque text

This article introduces an example of how to use ...

Kill a bunch of MySQL databases with just a shell script like this (recommended)

I was woken up by a phone call early in the morni...

Two ways to declare private variables in JavaScript

Preface JavaScript is not like other languages ​​...

Example of Vue transition to achieve like animation effect

Table of contents Results at a Glance Heart Effec...

JavaScript implements simple calculator function

This article example shares the specific code of ...

A brief discussion on whether CSS will block page rendering

Maybe everyone knows that js execution will block...

Summary of MySQL string interception related functions

This article introduces MySQL string interception...

A thorough analysis of HTML special characters

A Thorough Analysis of HTML (14) Special Characte...

Solve the problem of setting Chinese language pack for Docker container

If you use docker search centos in Docker Use doc...

Implementation example of uploading multiple attachments in Vue

Table of contents Preface Core code File shows pa...

Design Story: The Security Guard Who Can't Remember License Plates

<br />In order to manage the vehicles enteri...

mysql 8.0.19 win10 quick installation tutorial

This tutorial shares the installation tutorial of...