问

完全删除MySQL Ubuntu 14.04 LTS

手机用户2502922161 发布于 2022-12-28 18:49

我不知何故搞砸了我的Ubuntu服务器上的MySQL,无法修复它.我已经试过的每一个组合apt-get remove --purge mysql-server,apt-get autoremove,apt-get purge,google搜索了几个小时而已.

我已经放弃了.每次我尝试重新安装时都会收到错误.我受够了.我想删除我服务器上与MySQL相关的每个文件.

我每次尝试重新安装时都会收到此错误,这似乎很常见,但没有一个"修复"对我有用.我需要清理MySQL的所有系统.

Unable to set password for the MySQL "root" user                                                                                                        
An error occurred while setting the password for the MySQL administrative user. This may have happened because the account already has a password, or   
because of a communication problem with the MySQL server.                                                                                               
You should check the account's password after the package installation.                                                                                 
Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for more information.

在我全新安装服务器之前,请有人给我一套命令从我的系统中清除这个不合适的数据库.

Setting up mysql-server-5.5 (5.5.38-0ubuntu0.14.04.1) ...
140811 10:56:44 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.  
Processing triggers for libc-bin (2.19-0ubuntu6.1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Errors were encountered while processing:
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

我真的尝试了一切.每个mysql文件都被删除,但仍然无法正常安装.

2 个回答

要从Ubuntu中完全删除Mysql:
```
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
```
在此之后,如果您在重新安装时遇到问题,请尝试删除以下内容中的Mysql文件:
```
sudo rm -rf /var/lib/mysql
```
希望这可以帮助 .
2022-12-28 18:50 回答

平凡小迪
在MySQL更新后,我在Ubuntu 14.04 LTS上遇到了类似的问题.

我开始收到错误:"致命错误:无法在/var/log/mysql/error.log中打开和锁定权限表:文件格式不正确'用户'"

MySQL无法启动.

我通过删除以下目录解决了它:/ var/lib/mysql/mysql
```
sudo rm -rf /var/lib/mysql/mysql
```
这样就可以保留其他与DB相关的文件,只删除与mysql相关的文件.

运行这些之后:
```
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
```
然后重新安装mysql:
```
sudo apt-get install mysql-server
```
它工作得很好.
2022-12-28 18:51 回答

老鼠扛着刀找猫_592

撰写答案

今天，你开发时遇到什么问题呢？

立即提问

热门标签