我有两个mysql更新不能安装在20.04上:
2 updates could not be installed automatically. For more details,
see /var/log/unattended-upgrades/unattended-upgrades.log
我尝试了以下几点:
$ sudo apt install mysql-server-8.0 mysql-client-8.0
The following packages have unmet dependencies:
mysql-client-8.0 : Depends: mysql-common
我无法安装MySQL工作台。它告诉我们以下错误:
The following packages have unmet dependencies:
mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.3-0ubuntu4 is to be installed
Depends: libgtkmm-2.4-1c2a (>= 1:2.24.0) but 1:2.24.4-1ubuntu1 is to be installed
Depends: libpcre
我多次尝试将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
我需要在mysql和openvpn启动后运行一个脚本(Ubuntu表示ARM)。
我可以用这个.conf成功地运行这个脚本:
# my upstart for logging boot
start on (starting openvpn and started mysql)
script
cd /home/ubuntu/developedGZ/provaMySql/
./provaMySql
end script
脚本总是在mysql之后运行,而不是在openvpn之后运行。
我怎么能这么做?
下面是我在Ubuntu上执行的命令。
$ mysql -u root -p
mysql>GRANT ALL ON my_database.* TO user@'MY_REAL_IP' IDENTIFIED BY 'passwd';
$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
#bind-address = 127.0.0.1
$ sudo ufw enable
$ sudo ufw allow 3306
$ service mysql restart
但是,当我在Ubuntu上使用另一台计算机
当我尝试sudo apt-get install mysql-server时,我一直收到以下错误:
The following packages have unmet dependencies:
mysql-server : Depends: mysql-community-server (= 5.7.12-1ubuntu15.10) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
也不知道该怎么处理
当我试图安装mysql社区服务器时,
我将mysql的general_log_file变量的值更改为其他值,现在我试图将它更改回原来的/var/lib/mysql/ubuntu.log。但当我这么做的时候
SET GLOBAL general_log_file = '/var/lib/msyql/ubuntu.log';
我知道这个错误:
错误1231 (42000):变量'general_log_file‘不能设置为'/var/lib/msyql/ubuntu.log’
到底怎么回事?
我试图通过系统设置安装MySQL工作台,并得到以下错误:
The following packages have unmet dependencies:
mysql-workbench: Depends: libgcc1 (>= 1:3.0) but 1:6.0.1-0ubuntu1 is to be installed
Depends: libgdal.so.1-1.11.3 but it is a virtual package
Depends: libgtkmm-2.4-1v5 (>
我试图将MySQL5.1升级到5.5版本,因为官方的ubuntu存储库不提供5.5,所以我决定使用杜德布存储库。
当我更新包信息并输入sudo apt-get install mysql-server时,它删除了MySQL5.1,但不想安装5.5,因此出现了以下错误:
dpkg: error processing /var/cache/apt/archives/mysql-client-5.5_5.5.19-1~dotdeb.1_amd64.deb (--unpack):
trying to overwrite '/usr/bin/mysql', which is also
我正在使用厨师引导一个ec2 ubuntu13.04实例。我正在使用食谱。但我得到的是跟踪错误和引导停止不继续。
apt-get -q -y install libmysqlclient-dev=5.5.32-0ubuntu0.13.04.1 returned 100, expected 0
Resource Declaration:
In /var/chef/cache/cookbooks/mysql/recipes/client.rb
package mysql_pack do
action :install
48: end
49: end
/v
下面是怎么回事?为什么mysql不让我进去?我使用的是5.6
root@ip-10-93-145-98:/home/ubuntu# echo "grant all privileges on *.* to 'really'@'%' identified by 'stupid';" | mysql -u root -ptest101
Warning: Using a password on the command line interface can be insecure.
root@ip-10-93-145-98:/home/u
我已经开始学习django和python了,而且我还是个使用ubuntu的新手。对于我的第一个程序,我需要mysql,所以我已经安装了它,当我使用mysql命令时,我会得到这个结果。
user@ubuntu:~$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.5.34-0ubuntu0.12.10.1 (Ubuntu)
Copyright (c) 2000, 2013, Oracle and/or its affi
这个回答帮助了我,我已经安装了mysql-server-core-5.7,但是我得到了一个错误:
sudo mysql_secure_installation : command not found
mysql_secure是否安装在mysql-server-core-5.7的ubuntu16.04-64位上?
我怎么才能拿到呢?
我确实有一个问题,即使我完全卸载mysql并重新启动,它仍然没有安装mysql。这是我得到的错误:
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut
Statusinformationen werden eingelesen... Fertig
Die folgenden zusätzlichen Pakete werden installiert:
libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-client-core-5.5
ERROR 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'mysql dump --all-databases > dump.sql' at line
1. for ubuntu server
我怎么能解决呢?
我已经运行了Ubuntu 16.04 (全新安装-无需升级)。MySQL运行得很好--但是当我试图更新MySQL时,我得到了这个错误:
apt-get install
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0
我一直试图在我的Ubuntu 22上安装mysql,考虑到我遵循了我的指导员的一些代码,比如
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;
quit
之后,我尝试重新打开mysql并显示如下错误
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password