我已经用5.7版本安装了客户端和服务器的MySQL。
当我检查可用的MySQL包时:
$ sudo apt search mysql
mysql-client/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Client meta package depending on latest version
mysql-client-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
当我安装mysql-server时,会得到以下错误:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages hav
我想在ubuntu12.04 64位上安装MySql 5.1。MySql 5.1的原因是我想在不支持MySql 5.5的SQLAlchemy (python)中使用它。如果我尝试搜索存储库,那么只有MySql 5.5。我尝试了sudo apt-get install mysql-server=5.1.58,但是E: Version ‘5.1.66’ for ‘mysql-server’ was not found在这个页面上找到了https://launchpad.net/ubuntu/+source/mysql-5.1/5.1.66-0ubuntu0.11.10.2并下载了它。我安装它有问题
我正在开发Rails v2.3应用程序。并使用MySQL v5.1。
我需要在我的rake任务中停止和启动 mysql数据库,但是我不知道如何实现这个东西,有人能帮我吗?
namespace :db do
task :some_db_task => :environment do
#shut down mysql
...
#start mysql
end
end
顺便说一下,我正在Ubuntu机器上开发。
我尝试了exec "/etc/init.d/mysql stop",得到了以下错误消息:
Rather than
我尝试在Ubuntu20.04上使用OUTFILE,得到这个错误: MySQL服务器版本: 8.0.21
代码:
mysql> select * into OUTFILE '/home/yash/Desktop/data2.txt' from ticket;
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
我尝试了许多解决方案,但在Ubuntu 20.04上都不起作用
如果有人能给出
这太疯狂了。我已经尝试了所有的方法,但仍然抛出相同的错误。
我有一个数据库,希望它能在MySQL-Server上运行。在数据库开始时:
DROP SCHEMA IF EXISTS someDB;
CREATE SCHEMA someDB;
USE someDB;
当我尝试SHOW DATABASES LIKE 'someDB';时,它证实了它的存在。
我试过:
chmod获取它的完整路径,/var/lib/mysql/someDB/someDB.sql
停止MySQL-Server,删除someDB文件夹并再次启动服务器。
我删除了整个MySQL-Server并重新
我无法安装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服务器,它在windows上运行。现在我想从一个ubuntu ec2实例连接这个mysql数据库,但是它显示can't connect to mysql server at my IP (110 connection error)
有人能帮我从ubuntu连接到我的本地窗口吗?
供您参考:我甚至无法从ubuntu实例ping我的本地IP
为了django项目,我尝试在ubuntu16.04上安装mysql。安装时遇到了一些现有文件的问题,因此出现了以下错误:
mysql-server is already the newest version (5.7.19-0ubuntu0.16.04.1).
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
mysql-server : Depends: mysql-server-5.7 but it is
我有两个更新不能被自动安装。
当我尝试使用:sudo apt upgrade进行升级时,我收到了以下消息:
以下软件包被保存在后面: mysql-client mysql-server
因此,当我尝试手动安装它(比如:sudo apt install mysql-client )时,我得到了以下消息:
The following packages have unmet dependencies:
mysql-common : Conflicts: mysql-client-8.0 but 8.0.31-0ubuntu0.22.04.1 is to be installed
我遵循Ubuntu14.04的这数字海洋教程,为我的Rails项目在Ubuntu16.04上安装mysql。我可能错误地认为这个程序是一样的。
但是,当我运行命令sudo mysql_install_db时,会收到以下错误:
2016-06-15 18:40:36 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-06-15 18:40:36 [ERROR] The data directory needs to be specified.
如何完成
我正在试图在mysql-server上安装Ubuntu 20.04 LTS。但我知道这个错误:
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
libmysqlclient21 : Depends: mysq
一开始我做了
debian@osboxes:~/Desktop$ mysql -u root -p
Command 'mysql' not found, but can be installed with:
sudo apt install mysql-client-core-8.0 # version 8.0.18-0ubuntu0.19.10.1, or
sudo apt install mariadb-client-core-10.3 # version 1:10.3.20-0ubuntu0.19.10.1
然后我安装了
debian@osboxes:~/D