好吧,我有Manjaro/Linux 17.0,我尝试安装MariaDB,但总是得到相同的错误: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory") 我不知道该怎么办,我已经搜索了上千个论坛,我不能启动mariadb的守护进程系统控制,我试着做一个触摸在/run/mysqld/mysqld.sock但是,当我尝试启动MariaDB时,它拒绝了我的连接
我一直试图安装mariadb==1.0.4,但每次都声明./include/mariadb_python.h:27:19: fatal error: mysql.h: No such file or directory失败
Stacktrace如下所示:
Running setup.py install for mariadb ... error
ERROR: Command errored out with exit status 1:
command: /home/s/dbSync/bin/python3 -u -c 'import sys, setupt
我正在编写一个python脚本,它连接到一个MariaDB服务器(V10.1.12),并保存一些查询的结果。但是,在发送以下查询时:
sql = 'SELECT * FROM Monitor_Run_Tracking WHERE Entry IN (SELECT MAX(Entry) ' \
'FROM Monitor_Run_Tracking WHERE Run in ({0}) ' \
"AND WhenEntered<'{1}' GROUP BY Run)".format( runs
我刚刚安装了CentOS Linux,然后下载了MySQL tar文件来安装MySQL。我提取了6个封闭的rpm文件,并点击-server rpm文件来安装它。但是,我得到了以下对话框错误:
Failed to install file
Two packages provide the same name.
This is usually due to mixing packages from different software sources.
当我试图从Linux终端运行安装它时,我会得到以下更具体的日志,这似乎表明了与mariadb的冲突:
[root@localhost
我在我的ubuntu笔记本电脑就像这里描述的上安装了MariaDB5.5:
sudo add-apt-repository "deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu $(lsb_release -c -s) main"
到目前为止,它运行得很好,只有一件奇怪的事:当我进来的时候。
sudo su
LANG=C
aptitude install
我收到这些警告:
The following NEW packages will be installed:
linux-headers-3.11.0-12 lin
ubuntu:~$ sudo apt-get install mariadb-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 re
准确地说,我需要将mysql/MariaDB10.xx默认端口更改为端口号15501。
通过互联网,我发现它可以由包含一行port=3306的/etc/mysql/my.cnf更改,但在我的cnf文件中没有这样的行。
我的my.cnf内容:
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global de
Linux Ubuntu18.Linux10.3. MariaDBMariaDB服务无法启动引发systemd错误。原因似乎是userid包含一个点(.)。 systemd[1]: Invalid user/group name or numeric ID: myuser.withdot 配置: 来自MariaDB的服务文件是/etc/systemd/system/mariadb.service.d/migrated.conf,,它包含: [Service]
User=myuser.withdot
当我尝试登录mysql-workbench时,会遇到以下错误:
连接到MySQL服务器。在“读取初始通信包”时失去与MySQL服务器的连接,系统错误:0
查看我的mariadb数据库状态
MariaDB [(none)]> status;
--------------
mysql Ver 15.1 Distrib 10.6.5-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 13
Current database:
Current user: root@loc
我使用的是Fedora 29。我正在尝试使用以下命令运行mariadb.service:
systemctl start mariadb,
并给出错误:
Failed to start mariadb.service: Unit mariadb.service not found.
此外,我还尝试了next命令:
systemctl status mariadb
Unit mariadb.service could not be found.
systemctl start mariadb.service
Failed to start mariadb.service: Unit mariad
由于19.10升级Python不能再和MySQL对话了:
raise ImproperlyConfigured('MySQL driver not installed!')
peewee.ImproperlyConfigured: MySQL driver not installed!
但所有要求都已安装:peewee、mysqlclient、pysocks
也是libmysqlclient-dev, libmysqlclient21
更新:
mysql --version
mysql Ver 15.1 Distrib 10.3.17-MariaDB, for debian-
事实证明,下面询问的Docker/Windows上问题的原因是我这边的Hyper-V出现了本地网络问题。因此,这与Docker on Windows和Linux之间的区别无关,也与MariaDB没有任何关系。我想删除这个问题,但我不鼓励这样做,因为它已经得到了答案。
我是docker新手,但不是MySQL新手。我想在Docker里玩MariaDB。我在Windows10和Ubuntu上创建了Docker安装。
对于MariaDB容器,我遵循这里的描述,因为它似乎比这个更准确:。
我使用以下命令创建了一个MariaDB容器:
docker run --name mariadb -e MYSQL
我最近有一个新的MacBook Pro与M1芯片。我试图运行一些码头图像,但我收到了一些错误:
$ docker pull mariadb:5.5
5.5: Pulling from library/mariadb
no matching manifest for linux/arm64/v8 in the manifest list entries
$ docker run custom-mariadb-build-based-5.5:latest
WARNING: The requested image's platform (linux/amd64) does not match
p2@P2:~$sudo systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
p2@P2:~$sudo systemctl status mariadb
mariadb.service - MariaDB 10.3.31 database server
我跟踪关于如何在我的Ubuntu上构建MariaDB的MariaDB文档。
上面写着快跑
On a Debian based distribution:
apt-get build-dep mariadb-server-10.X
where X is the suffix of the major version.
所以我跑了
sudo apt-get build-dep mariadb-server-10.5
得到这个错误:
Reading package lists... Done
E: You must put some 'deb-src' URIs in your so
我需要将数据从平面文件加载到linux环境下的mariaDB中。我已经计划把mariaDB脚本放在外壳文件上。然后从cron调用shell。
mariadb脚本如下所示:
set @path = (select path_file from param);
set @tbl = (select table_name from param);
set @x = concat(
'LOAD DATA LOCAL INFILE ',
@path,
' INTO TABLE ', @tbl,