Solve the problem of PhPStudy MySQL startup failure under Windows system

Solve the problem of PhPStudy MySQL startup failure under Windows system

Report an error

The Apache\Nginx service started normally, but MySQL kept failing to start.

Solution Process

Check if the port is occupied

Open the system's built-in resource manager and check whether the listening port 3306 is occupied. In the figure below, port 3306 is occupied by mysqld.exe. mysqld.exe is the MySQL service that comes with phpstudy. If port 3306 is occupied by someone other than mysqld.exe, you can follow the steps below to close it.


Open the system's built-in services

Switch to local MySQL service

There are two MySQL services in the discovery service, one is MySQL and the other is MySQLa. The reason is that I have installed MySQL locally before, and the MySQL I installed is started by default. Now you just need to stop the MySQL service and start the MySQLa service.


Summarize

The above is what I introduced to you about solving the problem of PhPStudy MySQL startup failure under Windows system. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • Solution to the failure of MySQL service startup during MySQL 5.7.18 installation
  • Perfect solution to MySQL common insufficient memory startup failure
  • Solution to MySQL initialization and startup failure in Docker
  • Solution to MySQL database innodb startup failure and inability to restart
  • Quick solution to MySQL service startup failure under CentOS 7
  • Reasons and solutions for the failure of Mysql/MariaDB startup due to the progress bar state
  • Sharing the problem of mysql startup failure caused by disk full
  • mysql startup failure problem and scenario analysis

<<:  Example code and method of storing arrays in mysql

>>:  Basic use of javascript array includes and reduce

Recommend

How to implement navigation function in WeChat Mini Program

1. Rendering2. Operation steps 1. Apply for Tence...

Web lesson plans, lesson plans for beginners

Teaching Topics Web page Applicable grade Second ...

A mobile adaptive web page effect solves the problem of small display page

For work needs, I need to make a mobile phone adap...

Introduction to Kubernetes (k8s)

I had always wanted to learn Kubernetes because i...

Implementation of React configuration sub-routing

1. The component First.js has subcomponents: impo...

Vue local component data sharing Vue.observable() usage

As components become more detailed, you will enco...

How to deploy kafka in docker

Table of contents 1. Build Docker 2. Enter the co...

A brief discussion on Nginx10m+ high concurrency kernel optimization

What is high concurrency? The default Linux kerne...

Implementation of MySQL5.7 mysqldump backup and recovery

MySQL backup Cold backup:停止服務進行備份,即停止數據庫的寫入Hot ba...

How to install and configure Redis in CentOS7

Introduction There is no need to introduce Redis ...

Use of kubernetes YAML files

Table of contents 01 Introduction to YAML files Y...

Vertical and horizontal splitting of MySQL tables

Vertical Split Vertical splitting refers to the s...