MySQL的重装问题解决方法_MySQL
bitsCN.com
最近在工作上遇到了MySQL重装的问题，今天记录一下我的解决过程。
首先因为某些原因，我不得不把mysql卸载，然后重装，不论我用控制面板的卸载删除程序方式还是安全卫士的卸载，都会遇到一个问题，就是安装到如下图位置，server start时就程序无响应了，一直死在那里：
于是，网上到处找解决办法按照大多数人的说法，我试了不行，照死：
安装MySQL出示未响应，一般显示在安装MySQL程序最后一步的2，3项就不动了。
这种情况一般是你以前安装过MySQL数据库服务项被占用了。
解决方法：
一种方法：你可以安装MySQL的时候在这一步时它默认的服务名是“MySQL” 只需要把这个名字改了就可以了。
二种方法：
1、卸载MySQL
2、删除安装目录及数据存放目录
3、在注册表(regedit)查询mysql，全部删除
4、在c盘查询MySQL，全部删除
5、重新安装就好了
注意的是注册表 cmd -> regedit
1.HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Application/MySQL 目录
2.HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Application/MySQL 目录
3.HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Application/MySQL 目录
4.HKEY_LOCAL_MACHINE/SYSTEM/CurrentControl001t/Services/MYSQL 目录
5.HKEY_LOCAL_MACHINE/SYSTEM/CurrentControl002/Services/MYSQL 目录
6.HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/MYSQL 目录
7.删除C:/Documents and Settings/All Users/Application Data/MySQL 目录
上面两种方法任选一种，重新安装新版MYSQL 就OK了。
注意：删除完成后一定要重启计算机，再进行安装。
用以上方法装了一下午，最终还是不行。
最后，因为我的服务器是Windows Server 2008 RC
所以我想是不是兼容性的问题，我下的是最新的mysql5.5.28
于是在如下图这一步的时候我把勾去掉了：
然后找到MySQL安装目录下的bin文件夹下的“MySQLInstanceConfig.exe”程序，右击属性如下图设置：
双击MySQLInstanceConfig.exe”程序一步一步下来，安装成功了终于，哈哈
bitsCN.com
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PHP's big data structure processing skills
May 08, 2024 am 10:24 AM
Big data structure processing skills: Chunking: Break down the data set and process it in chunks to reduce memory consumption. Generator: Generate data items one by one without loading the entire data set, suitable for unlimited data sets. Streaming: Read files or query results line by line, suitable for large files or remote data. External storage: For very large data sets, store the data in a database or NoSQL.
How to use MySQL backup and restore in PHP?
Jun 03, 2024 pm 12:19 PM
Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.
How to optimize MySQL query performance in PHP?
Jun 03, 2024 pm 08:11 PM
MySQL query performance can be optimized by building indexes that reduce lookup time from linear complexity to logarithmic complexity. Use PreparedStatements to prevent SQL injection and improve query performance. Limit query results and reduce the amount of data processed by the server. Optimize join queries, including using appropriate join types, creating indexes, and considering using subqueries. Analyze queries to identify bottlenecks; use caching to reduce database load; optimize PHP code to minimize overhead.
How to insert data into a MySQL table using PHP?
Jun 02, 2024 pm 02:26 PM
How to insert data into MySQL table? Connect to the database: Use mysqli to establish a connection to the database. Prepare the SQL query: Write an INSERT statement to specify the columns and values to be inserted. Execute query: Use the query() method to execute the insertion query. If successful, a confirmation message will be output.
How to create a MySQL table using PHP?
Jun 04, 2024 pm 01:57 PM
Creating a MySQL table using PHP requires the following steps: Connect to the database. Create the database if it does not exist. Select a database. Create table. Execute the query. Close the connection.
How to use MySQL stored procedures in PHP?
Jun 02, 2024 pm 02:13 PM
To use MySQL stored procedures in PHP: Use PDO or the MySQLi extension to connect to a MySQL database. Prepare the statement to call the stored procedure. Execute the stored procedure. Process the result set (if the stored procedure returns results). Close the database connection.
How to fix mysql_native_password not loaded errors on MySQL 8.4
Dec 09, 2024 am 11:42 AM
One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app
How to disable sticky keys in win10? Tips for turning off sticky keys in win10 using the control panel
Jun 05, 2024 pm 10:38 PM
This article will introduce how to use the control panel to disable sticky keys in Win10 system. Through simple steps, it helps users easily manage sticky keys and pop-up window settings on their computers to improve operating efficiency and computer experience. What are sticky keys? Have you ever wondered what sticky bonds are and what they do? This is an accessibility feature in Windows 11 and Windows 10 designed to help users who have difficulty holding down two or more keys at the same time. In other words, Sticky Keys allows you to press one key at a time instead of pressing keyboard shortcuts simultaneously. For example, to enter uppercase letters, you must hold down the SHIFT key and the letter you want to type. If you have a disability that prevents you from doing this, Sticky Keys can help. If Sticky Keys is enabled, when you press
