Mario's questions

---我已经尝试过（两次）--- mariadb 失败后安装 mysql-server mariadb 不是问题，因为虽然它安装在这台计算机上，但所有依赖项都已被删除，如下所示。终端截图如下 https://pastebin.ubuntu.com/p/9pPQDbFzYf/情况可能类似但情况并非如此。

我已经在 synaptic 中删除了 Libmysqlclient21，因为它出现故障，试图在 synaptic 上成功卸载 MySQL 并重新安装它 synaptic UNsuccessfully，显然有一个我找不到的正在运行的 MySQL 进程，这阻止了 mysql-server-8.0 的安装（ mysql-client、client-8.0、client-core-8.0、server 和 server-core-8.0 重新安装就好了）。接下来你会发现 ubuntu 终端捕获清理https://pastebin.ubuntu.com/p/pJCxYm5K2w/，以及显示与“自身”冲突的突触屏幕捕获，ps aux 报告没有运行 mysql 的实例，

Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 220062 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.5ubuntu2_all.deb ...
Unpacking mysql-common (5.8+1.0.5ubuntu2) ...
Selecting previously unselected package mysql-client-core-8.0.
Preparing to unpack .../mysql-client-core-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...
Unpacking mysql-client-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../mysql-client-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.20-0ubuntu0.20.04.1) ...
Selecting previously unselected package mysql-server-core-8.0.
Preparing to unpack .../mysql-server-core-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...
Unpacking mysql-server-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...
Setting up mysql-common (5.8+1.0.5ubuntu2) ...
update-alternatives: warning: alternative /etc/mysql/mysql.cnf (part of link group my.cnf) doesn't exist; removing from list of alternatives
update-alternatives: warning: /etc/alternatives/my.cnf is dangling; it will be updated with best choice
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 220262 files and directories currently installed.)
Preparing to unpack .../mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 5
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing archive /var/cache/apt/archives/mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb (--unpack):
 new mysql-server-8.0 package pre-installation script subprocess returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up mysql-client-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...
Setting up mysql-server-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...
Setting up mysql-client-8.0 (8.0.20-0ubuntu0.20.04.1) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for libc-bin (2.31-0ubuntu9) ...

在突触上重新安装的输出

Preconfiguring packages ...
(Reading database ... 221833 files and directories currently installed.)
Preparing to unpack .../mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 5
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing archive /var/cache/apt/archives/mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb (--unpack):
 new mysql-server-8.0 package pre-installation script subprocess returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 is not installed.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server

第二次重新安装尝试

Preconfiguring packages ...  
Selecting previously unselected package mysql-common.  
(Reading database ... 220062 files and directories currently installed.) 
Preparing to unpack .../mysql-common_5.8+1.0.5ubuntu2_all.deb ... 
Unpacking mysql-common (5.8+1.0.5ubuntu2) ...  
Selecting previously unselected package mysql-client-core-8.0.  
Preparing to unpack .../mysql-client-core-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...  
Unpacking mysql-client-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...  
Selecting previously unselected package mysql-client-8.0.  
Preparing to unpack .../mysql-client-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...  
Unpacking mysql-client-8.0 (8.0.20-0ubuntu0.20.04.1) ...  
Selecting previously unselected package mysql-server-core-8.0.  
Preparing to unpack .../mysql-server-core-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...  
Unpacking mysql-server-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...  
Setting up mysql-common (5.8+1.0.5ubuntu2) ...  
update-alternatives: warning: alternative /etc/mysql/mysql.cnf (part of link group my.cnf) doesn't exist;   
  removing from list of alternatives
update-alternatives: warning: /etc/alternatives/my.cnf is dangling; it will be updated with best choice  
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode  
Selecting previously unselected package mysql-server-8.0.  
(Reading database ... 220262 files and directories currently installed.)  
Preparing to unpack .../mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb ...  
Failed to stop mysql.service: Unit mysql.service not loaded.  
invoke-rc.d: initscript mysql, action "stop" failed.  
invoke-rc.d returned 5  
There is a MySQL server running, but we failed in our attempts to stop it.  
Stop it yourself and try again!  
dpkg: error processing archive /var/cache/apt/archives/mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb (--unpack):  
 new mysql-server-8.0 package pre-installation script subprocess returned error exit status 1  
Errors were encountered while processing:  
 /var/cache/apt/archives/mysql-server-8.0_8.0.20-0ubuntu0.20.04.1_amd64.deb  
E: Sub-process /usr/bin/dpkg returned an error code (1)  
A package failed to install.  Trying to recover:  
Setting up mysql-client-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...  
Setting up mysql-server-core-8.0 (8.0.20-0ubuntu0.20.04.1) ...  
Setting up mysql-client-8.0 (8.0.20-0ubuntu0.20.04.1) ...  
Processing triggers for man-db (2.9.1-1) ...  
Processing triggers for libc-bin (2.31-0ubuntu9) ...  

ps aux命令输出，没有与 MySQL 相关的运行进程（据我所知） https://pastebin.ubuntu.com/p/z4cCYXBykW/

十分感谢

我完全忘记了 MySQL 已经安装在这台特定的计算机上并且我安装了 MariaDB，我也不知道在同一台计算机上同时安装两个软件包的后果，我一直在尝试完全卸载这两个安装并删除两者的依赖关系其中。我已经在网上查找了几个关于如何执行此操作的教程，但我仍然无法运行 MySQL，您将在下面找到终端窗口的屏幕截图以及我尝试过的许多尝试解决方案的列表，不幸的是我有尝试了很多，以至于我无法回忆起我尝试它们的顺序，我只想安装一个有效的 MySQL，但不知何故，我无法从以前的安装中删除一些东西，并且 MySQL 安装不起作用，我获取 dpkg：警告。任何和所有的帮助将不胜感激。(Ubuntu 20.04)

这是终端窗口的屏幕截图。

homeserver@ubuserv:~/Desktop$ ps ax | grep mysql
   4958 pts/0    S+     0:00 grep --color=auto mysql
homeserver@ubuserv:~/Desktop$ sudo mysql_secure_installation utility
[sudo] password for homeserver: 

Securing the MySQL server deployment.

Enter password for user root: 
Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
homeserver@ubuserv:~/Desktop$ mysql --version
mysql  Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
homeserver@ubuserv:~/Desktop$ sudo systemctl stop mysql
Failed to stop mysql.service: Unit mysql.service not loaded.
homeserver@ubuserv:~/Desktop$ sudo systemctl stop mysql
Failed to stop mysql.service: Unit mysql.service not loaded.
homeserver@ubuserv:~/Desktop$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
homeserver@ubuserv:~/Desktop$ sudo apt install synaptic
Reading package lists... Done
Building dependency tree       
Reading state information... Done
synaptic is already the newest version (0.84.6ubuntu5).
The following packages were automatically installed and are no longer required:
  hplip-data printer-driver-postscript-hp python3-renderpm
  python3-reportlab python3-reportlab-accel
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.

homeserver@ubuserv:~/Desktop$ sudo service mysql restart
[sudo] password for homeserver: 
Failed to restart mysql.service: Unit mysql.service not found.
homeserver@ubuserv:~/Desktop$ apt search mysql | grep "\[install"
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
libdbi-perl/focal,now 1.643-1 amd64 [installed]
libmysqlclient21/focal-updates,focal-security,now 8.0.20-0ubuntu0.20.04.1 amd64 [installed]
librdf0/focal,now 1.0.17-1.1ubuntu1 amd64 [installed,automatic]
mysql-client-8.0/focal-updates,focal-security,now 8.0.20-0ubuntu0.20.04.1 amd64 [installed]
mysql-client-core-8.0/focal-updates,focal-security,now 8.0.20-0ubuntu0.20.04.1 amd64 [installed]
mysql-common/focal,focal,now 5.8+1.0.5ubuntu2 all [installed]
mysql-server/focal-updates,focal-updates,focal-security,focal-security,now 8.0.20-0ubuntu0.20.04.1 all [installed]
mysql-server-8.0/focal-updates,focal-security,now 8.0.20-0ubuntu0.20.04.1 amd64 [installed]
mysql-server-core-8.0/focal-updates,focal-security,now 8.0.20-0ubuntu0.20.04.1 amd64 [installed]
rsyslog/focal,now 8.2001.0-1ubuntu1 amd64 [installed,automatic]
homeserver@ubuserv:~/Desktop$ sudo apt -f install mysql-server
[sudo] password for homeserver: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-server is already the newest version (8.0.20-0ubuntu0.20.04.1).
0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.
homeserver@ubuserv:~/Desktop$ sudo apt -f install mysql-client
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  mysql-client
0 upgraded, 1 newly installed, 0 to remove and 10 not upgraded.
Need to get 9.424 B of archives.
After this operation, 110 kB of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 mysql-client all 8.0.20-0ubuntu0.20.04.1 [9.424 B]
Fetched 9.424 B in 1s (14,4 kB/s)       
Selecting previously unselected package mysql-client.
dpkg: warning: files list file for package 'mysql-server-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-common' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-client-core-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-server-core-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-client-8.0' missing; assuming package has no files currently installed
(Reading database ... 223970 files and directories currently installed.)
Preparing to unpack .../mysql-client_8.0.20-0ubuntu0.20.04.1_all.deb ...
Unpacking mysql-client (8.0.20-0ubuntu0.20.04.1) ...
Setting up mysql-client (8.0.20-0ubuntu0.20.04.1) ...
homeserver@ubuserv:~/Desktop$ dir
homeserver@ubuserv:~/Desktop$ cd ..
homeserver@ubuserv:~$ dir
Desktop  Documents  Downloads  Music  Pictures  Public  snap  Templates  Videos
homeserver@ubuserv:~$ cd Downloads
homeserver@ubuserv:~/Downloads$ dir
bprocessor-M11.zip    ClientBridgeWorking.bin        RepeaterBridgeWorking3.bin
ClientBridgeWorking2.bin  mysql-apt-config_0.8.15-1_all.deb  teamviewer_15.5.3_amd64.deb
homeserver@ubuserv:~/Downloads$ sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
Selecting previously unselected package mysql-apt-config.
dpkg: warning: files list file for package 'mysql-server-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-common' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-client-core-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-server-core-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-client-8.0' missing; assuming package has no files currently installed
(Reading database ... 223974 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.15-1_all.deb ...
Unpacking mysql-apt-config (0.8.15-1) ...
Setting up mysql-apt-config (0.8.15-1) ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
homeserver@ubuserv:~/Downloads$ sudo service mysql status
Unit mysql.service could not be found.
homeserver@ubuserv:~/Downloads$ sudo service mysql start
Failed to start mysql.service: Unit mysql.service not found.
homeserver@ubuserv:~/Downloads$ sudo dpkg -P mysql
dpkg: warning: ignoring request to remove mysql which isn't installed
homeserver@ubuserv:~/Downloads$ sudo apt-get install --reinstall mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 10 not upgraded.
Need to get 9.540 B of archives.
After this operation, 0 B of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 mysql-server all 8.0.20-0ubuntu0.20.04.1 [9.540 B]
Fetched 9.540 B in 1s (17,6 kB/s)       
dpkg: warning: files list file for package 'mysql-server-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-common' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-client-core-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-server-core-8.0' missing; assuming package has no files currently installed
dpkg: warning: files list file for package 'mysql-client-8.0' missing; assuming package has no files currently installed
(Reading database ... 223979 files and directories currently installed.)
Preparing to unpack .../mysql-server_8.0.20-0ubuntu0.20.04.1_all.deb ...
Unpacking mysql-server (8.0.20-0ubuntu0.20.04.1) over (8.0.20-0ubuntu0.20.04.1) ...
Setting up mysql-server (8.0.20-0ubuntu0.20.04.1) ...

SU终端

homeserver@ubuserv:~/Desktop$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
homeserver@ubuserv:~/Desktop$ sudo apt install synaptic
Reading package lists... Done
Building dependency tree       
Reading state information... Done
synaptic is already the newest version (0.84.6ubuntu5).
The following packages were automatically installed and are no longer required:
  hplip-data printer-driver-postscript-hp python3-renderpm
  python3-reportlab python3-reportlab-accel
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.
homeserver@ubuserv:~/Desktop$ synaptic
homeserver@ubuserv:~/Desktop$ sudo su
root@ubuserv:/home/homeserver/Desktop# synaptic
root@ubuserv:/home/homeserver/Desktop# gksu synaptic

Command 'gksu' not found, did you mean:

  command 'gosu' from deb gosu (1.10-1)
  command 'ksu' from deb heimdal-clients (7.7.0+dfsg-1ubuntu1)
  command 'ksu' from deb krb5-user (1.17-6ubuntu4)

Try: apt install <deb name>

root@ubuserv:/home/homeserver/Desktop# gksu synaptic

Command 'gksu' not found, did you mean:

  command 'ksu' from deb heimdal-clients (7.7.0+dfsg-1ubuntu1)
  command 'ksu' from deb krb5-user (1.17-6ubuntu4)
  command 'gosu' from deb gosu (1.10-1)

Try: apt install <deb name>

root@ubuserv:/home/homeserver/Desktop# synaptic admin://
root@ubuserv:/home/homeserver/Desktop# xhost +si:localuser:root
localuser:root being added to access control list
root@ubuserv:/home/homeserver/Desktop# synaptic
^C
root@ubuserv:/home/homeserver/Desktop# synaptic
root@ubuserv:/home/homeserver/Desktop# synaptic
root@ubuserv:/home/homeserver/Desktop# synaptic
^C
root@ubuserv:/home/homeserver/Desktop# synaptic
root@ubuserv:/home/homeserver/Desktop# synaptic
root@ubuserv:/home/homeserver/Desktop# cd..
cd..: command not found
root@ubuserv:/home/homeserver/Desktop# cd ..
root@ubuserv:/home/homeserver# cd ..
root@ubuserv:/home# cd ..
root@ubuserv:/# cd ..
root@ubuserv:/# dir
bin    dev   lib    libx32  mnt   root  snap      sys  var
boot   etc   lib32  lost+found  opt   run   srv       tmp
cdrom  home  lib64  media   proc  sbin  swapfile  usr
root@ubuserv:/# sudo aptitude install mysql-server
sudo: aptitude: command not found
root@ubuserv:/# sudo apt install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-server is already the newest version (8.0.20-0ubuntu0.20.04.1).
0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.
root@ubuserv:/# 

在终端发出的命令

$ sudo apt install mysql-server
$ sudo mysql_secure_installation
$ sudo mysql
$ sudo apt remove mysql-server
$ sudo apt install mariadb-server
$ sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
$ sudo service mysql restart
$ sudo service mysql stop
$ sudo service mysql start
$ systemctl status mariadb.service
$ set mysql/config/mysqld/innodb_force_recovery=1
$ systemctl start mariadb
$ find /etc -name *.cnf
$ sudo apt-get purge mariadb-server
$ sudo dpkg -l | grep mariadb
$ sudo nano /etc/mysql/debian.cnf
$ sudo mysql_secure_installation
$ apt-get purge mysql-server\*
$ rm -rf /etc/my.cnf /etc/mysql
$ sudo apt-get remove --purge mysql*
$ sudo apt-get purge mysql*
$ sudo apt-get autoclean
$ sudo apt-get remove dbconfig-mysql
$ sudo apt-get remove ––purge mariadb-server
$ del mysql*
$ rm mysql*
$ sudo apt-get clean
$ ps -A|grep mysql
$ sudo pkill mysql
$ ps -A|grep mysqld
$ ps ax | grep mysql
$ sudo nano sources.list
$ sudo apt purge mariadb-*
$ sudo rm -rf /usr/share/mysql/
$ find mariadb.repo
$ find mariadb*
$ apt search mysql | grep "\[install"
$ sudo apt -f install mysql-server
$ sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb

作为 SU 发出的命令

# service mysql stop
# killall -KILL mysql mysqld_safe mysqld
# apt-get --yes purge mysql-server mysql-client
# apt-get --yes autoremove --purge
# apt-get autoclean
# deluser --remove-home mysql
# delgroup mysql
# rm -rf /etc/apparmor.d/abstractions/mysql /etc/apparmor.d/cache/usr.sbin.mysqld /etc/mysql /var/lib/mysql /var/log/mysql* /var/log/upstart/mysql.log* /var/run/mysqld
# updatedb
# rm ~/.mysql_history
# sudo apt-get purge mariadb-server
# sudo dpkg -l | grep mariadb
# sudo apt-get purge mariadb-server 
# sudo dpkg -l | grep mariadb 
# edit /etc/mysql/mysql.conf.d/mysqld.cnf
# killall -KILL mysql mysqld_safe mysqld
# apt-get --yes purge mysql-server mysql-client
# apt-get --yes autoremove --purge
# apt-get autoclean
# deluser --remove-home mysql
# delgroup mysql
# apt-get remove --purge mariadb
# apt-get remove --purge mariadb*
# sudo rm -rf /etc/mysql/
# sudo apt install mysql-server
# sudo apt-get autoclean && sudo apt-get --force-yes remove mysql-community-server-dbgsym mysql-community-server mysql-server
# xhost +si:localuser:root
# synaptic

更新

我已经删除了突触中的 Libmysqlclient21，因为它看起来已损坏，尝试从突触成功卸载 MySQL 并从突触重新安装它失败，显然有一个我找不到的正在运行的 MySQL 进程，这阻止了 mysql-server-8.0 的安装（mysql-client、client-8.0、client-core-8.0、server 和 server-core-8.0 重新安装就好了）。接下来你会发现屏幕截图 https://pastebin.ubuntu.com/p/pJCxYm5K2w/

还 - -

internal Error, No file name for mysql-server:amd64

我无法从 Windows PC 上看到我的 Ubuntu 18.04 PC（充当文件和媒体服务器）。我已经安装了 Samba、Tasksel、System-config-samba、python-glade2、samba-common、smbclient。将 avahi-daemon 编辑为 0，在 samba 中创建了“me”和“netguest”用户，sudo ufw 允许“Samba”（即使防火墙已禁用），sudo chmod 777 /media/mydrive/Mystuff（也包含所有共享文件夹） . Windows PC 在 Homenet 网络上，Ubuntu PC 有一个静态 IP (192.168.0.10)，它可以被 ping，但不能访问或看到。有两件事我不知道它们是否影响，我有 2 个路由器，第二个用作范围扩展器，但它是唯一可以通过线连接到 Ubuntu PC 的，其余的是通过 wi-fi 连接。附加了 smb.conf 文件。感谢您提供的任何帮助。