我一直使用Ubuntu托管我的服务器,我想尝试新的MySQL版本。因此,我从他们的官方站点下载了MySQL 5.6.10 (.deb),并按如下方式安装:
MySQL安装教程
一切都很顺利,除了我要登录的时候。我发现了一个错误:
root@person-ubuntu:/opt/mysql/server-5.6# mysql -u root -p
The program 'mysql' is currently not installed. You can install it by typing:
apt-get install mysql-client-core-5.5
但如
我刚从19.10升级到20.04。一切都进行得很顺利,但我对mysql有问题。在这里,当前安装的软件包:
$ dpkg -l | grep mysql
ii libmysqlclient21:amd64 8.0.20-0ubuntu0.20.04.1 amd64 MySQL database client library
ii mysql-apt-config 0.8.15-1
在这之后它就会停下来并结冰。
The following packages will be upgraded:
libmysqlclient15off mysql-client mysql-client-5.0 mysql-common
4 packages upgraded, 4 newly installed, 0 to remove and 49 not upgraded.
Need to get 38.0MB of archives. After unpacking 91.1MB will be used.
Do you want to conti
当我试图使用mysql命令时,我错误地删除了mysql的一些依赖文件,我得到了以下错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
我试过重新安装mysql服务器,但仍然没有解决。
我该怎么做才能让一切恢复正常。
编辑:操作系统是UBUNTU。日志文件(var/ log /mysql_log)为字节。那里什么都没有。
请检查这个问题的截图。https://stackoverflow.com/questio
我多次尝试将MySQL从我的系统中完全删除,但没有成功。我知道这些错误:
📷
📷
我也尝试过其他命令,但没有成功。我该怎么办?
下面是apt list --installed | grep mysql的输出:
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
default-libmysqlclient-dev/focal,now 1.0.5ubuntu2 amd64 [installed]
libmysqlclient-dev/focal-updates,focal-securit
当我运行命令sudo apt-get install mysql-server时,我会得到以下错误.
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libevent-core-2.0-5 mysql-client-5.7 mysql-common mysql-server-5.7
Suggested packages:
mailx tinyca
The following NEW packages
我试图在LinuxUbuntu16.04中打开Mysql,但我得到了一个错误:
ilqar@ubuntu:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
然后我尝试启动mysql服务器:
ilqar@ubuntu:~$ sudo service mysql start
Job for mysql.service failed becaus
说到Ubuntu,我是个菜鸟。我试图在我的系统(Ubuntu20.04.1LTS)上安装一个程序并更新几个程序,但是我一直得到一个MySQL错误。我有点不明白这一切意味着什么:
update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/me
cab/dic/debian (mecab-dictionary) in auto mode
Setting up mysql-server-8.0 (8.0.22-0ubuntu0.20.04.3) ...
update-alternatives: usin
我正在尝试在ubuntu22.04LTS上安装mysql服务器,但是我得到了以下dpkg错误消息。我怎样才能解决这个问题?
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0 mysql-server-ore-8
我需要完全删除关于MySQL的所有内容。它没有启动,所以我决定删除它。但是,在安装过程中发生了这样的情况:
sta@daPC:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libmysqlclient18 mysql-client-5.6 my
Mysql工作得完美无缺。但是,这些被阻止的数据包已经与apt包管理器搞混了。
The following packages have been kept back:
mysql-client mysql-server 0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
Mysql "apt-cache策略mysql-client mysql-server“应@popey的请求
apt-cache policy mysql-client mysql-server
mysq
我正在尝试从终端从Ubuntu 20.04服务器连接到Azure Database for MySQL-Server。直到两天前,这一切都运行得很好。现在,当我按enter键时,显示mysql警告,但什么也没有发生: user@ubuntu2004:~$ mysql -uuser -ppassword -hmyserver.mysql.database.azure.com
mysql: [Warning] Using a password on the command line interface can be insecure. MySQL服务器版本Ubuntu服务器:版本8.0.27-
我试图在Ubuntu20.04中安装/删除和重新安装/修复Mysql和Workbench,但是始终得到以下消息:
Building dependency tree
Reading state information... Done
mysql-server is already the newest version (8.0.20-2ubuntu20.04).
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet de
使用ubuntu 17.04,mysql 5.7。
我使用权限将/var/lib/mysql复制到我的/newlocation。我手动检查了新位置中的所有用户和组以及文件和文件夹权限是否与在/var/lib/mysql.I中更改了mysql配置中的datadir相同。我卸载了设备,所以这不再是问题了。/newlocation所在的分区与/var/lib/mysql是不同的,但是它被挂载在fstab中,并且也是ext4,所以一切都应该很好,但是在尝试启动mysql服务器时,我从systemctl收到了这个错误。
mysqld: Can't change dir to '/newl
我一直在互联网上寻找解决这个问题的方法,但一直未能找到解决办法。在尝试运行sudo apt-get upgrade时,我一直会收到这些错误。我不太清楚我应该提供什么信息,请随便问。
下面是我在运行sudo apt-get upgrade时得到的信息
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
mysql-server
我以前安装了MariaDB,我希望在我的服务器上安装MySQL 5.7。我用mariadb和mysql清除了所有文件。尽管当我安装MySQL-Server-5.7时,我得到了以下错误。(在搜索时,错误似乎是因为之前安装的Maria)。同样在日志中,您将看到mysql--公共是maria的一种形式。如果这是有意的或正确的,那就开始吧。(Ubuntu 18.04)
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional pack
因为mysql-client和mysql-server获得了8.0.33的更新,所以它们将被阻止,而不是升级。
The following packages have been kept back:
mysql-client mysql-server
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
安装mysql-client-8.0和mysql-server-8.0不能工作:
[...]
apt install mysql-server-8.0 mysql-client-8.0
[...]
The followi
我需要在Ubuntu20.04上安装MySQL 5.7 :我完成了这个这里。在我做apt purge mysql-client mysql-server之前,它将8.0.X版本从我的系统中删除。
但是在安装apt install mysql-community-server=5.7.35-1ubuntu18.04时,我得到了错误:
-- Automatic restarting of the unit mysql.service has been scheduled, as the
result for
-- the configured Restart= se
也许我在安装MySQL时犯了一个严重的错误,结果是这样的。
问题
MySQL包不是完全的installed.this是我得到的
sudo service mysql start什么也不做
mysql -u root输出:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
aptitude search mysql |grep ^i
产出:
i mysql-client - MySQL database cli
我正在尝试安装mysql-server-5.6包,但我有以下错误消息:
root@ps481138:/home/nikitasorokin# apt-get install mysql-server-5.6
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server-5.6 is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 941 n
我不知道是什么问题,但我很确定在我的MySQL安装中出现了严重的问题。我已经在以下链接中尝试了几乎所有的解决方案:如何修复损坏的包安装(mysql)、如何完全删除MySQL以进行清洁安装、如何完全卸载MySQL?。但不幸的是,什么也没起作用。在尝试每种解决方案时,都会产生一个常见错误,如下所示:
The following packages have unmet dependencies:
libmysqlclient20 : Depends: mysql-common (>= 5.7.20-1ubuntu16.04)
Breaks: libmy
我正在尝试使用以下方法安装MySQL:
sudo apt install mysql-server
在这个过程的最后,我得到了以下信息:
E: Sub-process /usr/bin/dpkg returned an error code (1)
整个投入/产出:
ubuntu@ubuntu:~$ sudo apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages