mysql - Raspberry Pi4，mariadb install，mysql comand not found 问题

Question

嗨，伙计们，我已经使用 pip3 和一个轮子包在树莓派上安装了 mariadb。我在 pi 上没有互联网访问权限，因此必须在另一台机器上进行 pip 下载并复制它。当我执行“pip3 show mariadb”命令时，我得到以下信息：

Version: 1.0.7
Summary: Python MariaDB extension
Home-page: https://www.github.com/mariadb-corporation/mariadb-connector-python
Author: Georg Richter
Author-email: None
License: LGPL 2.1
Location: /home/pi/.local/lib/python3.7/site-packages
Requires:
Required-by:

由此我假设它安装正常，但我似乎无法使用“mysql -u root -p”命令运行它。我收到“mysql：找不到命令”错误。我是否必须编辑我的 PATH，如果是，我怎样才能找到应用程序的路径？我已经对“mysql”进行了完整的文件搜索，但只得到了几个我知道它们是什么的文件，但它们不是主应用程序。

这就是我安装 mariadb 的方式：

pi@PTGM2:~/mariadb-deps $ pip3 install mariadb-1.0.7-cp37-cp37m-linux_armv7l.whl -f ./ --no-index --no-deps
Looking in links: ./
Processing ./mariadb-1.0.7-cp37-cp37m-linux_armv7l.whl
Installing collected packages: mariadb
Successfully installed mariadb-1.0.7

从我这样创建的文件中：

pi@PiMainServer:~ $ pip download mariadb -d '/home/pi/mariadb-deps'
Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
Collecting mariadb
  Downloading https://www.piwheels.org/simple/mariadb/mariadb-1.0.7-cp37-cp37m-l                                                                                                                                                             inux_armv7l.whl (235 kB)
     |████████████████████████████████| 235 kB 100 kB/s
Saved ./mariadb-deps/mariadb-1.0.7-cp37-cp37m-linux_armv7l.whl
Successfully downloaded mariadb

看来我只是在安装连接器，所以我设法获取了 mariadb-server deb 文件，但是当我尝试安装它时，我收到一个错误，它需要 mariadb-server-10.3！我以为我在安装 mariadb-server-10.3 ？？？这就是我得到的：

pi@PTGM2:/var/cache/apt/archives $ sudo dpkg -i mariadb-server_1%3a10.3.29-0+deb10u1_all.deb
(Reading database ... 160964 files and directories currently installed.)
Preparing to unpack mariadb-server_1%3a10.3.29-0+deb10u1_all.deb ...
Unpacking mariadb-server (1:10.3.29-0+deb10u1) over (1:10.3.29-0+deb10u1) ...
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.3 (>= 1:10.3.29-0+deb10u1); however:
  Package mariadb-server-10.3 is not installed.

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

好的，现在我已经安装了 mysql-common、mariadb-common 和连接器，但仍然出现错误：

pi@PTGM2:/var/cache/apt/archives $ sudo dpkg -i mariadb-common_1%3a10.3.29-0+deb               10u1_all.deb
Selecting previously unselected package mariadb-common.
(Reading database ... 160988 files and directories currently installed.)
Preparing to unpack mariadb-common_1%3a10.3.29-0+deb10u1_all.deb ...
Unpacking mariadb-common (1:10.3.29-0+deb10u1) ...
Setting up mariadb-common (1:10.3.29-0+deb10u1) ...
update-alternatives: using /etc/mysql/mariadb.cnf to provide /etc/mysql/my.cnf (               my.cnf) in auto mode

pi@PTGM2:/var/cache/apt/archives $ sudo dpkg -i libmariadb3_1%3a10.3.29-0+deb10u               1_armhf.deb
(Reading database ... 160993 files and directories currently installed.)
Preparing to unpack libmariadb3_1%3a10.3.29-0+deb10u1_armhf.deb ...
Unpacking libmariadb3:armhf (1:10.3.29-0+deb10u1) over (1:10.3.29-0+deb10u1) ...
Setting up libmariadb3:armhf (1:10.3.29-0+deb10u1) ...
Processing triggers for libc-bin (2.28-10+rpi1) ...
pi@PTGM2:/var/cache/apt/archives $ sudo dpkg -i mariadb-server_1%3a10.3.29-0+deb               10u1_all.deb
(Reading database ... 160993 files and directories currently installed.)
Preparing to unpack mariadb-server_1%3a10.3.29-0+deb10u1_all.deb ...
Unpacking mariadb-server (1:10.3.29-0+deb10u1) over (1:10.3.29-0+deb10u1) ...
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.3 (>= 1:10.3.29-0+deb10u1); however               :
  Package mariadb-server-10.3 is not installed.

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

标签： mysqlmariadb