termux安装mysql数据库
查看软件包
~ $ pkg list-all |grep mar
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
cmark-static/stable 0.30.2 aarch64
cmark/stable 0.30.2 aarch64
libmariadbcpp/stable 1.1.0-2 aarch64
mariadb-static/stable 2:10.6.7-1 aarch64
mariadb/stable 2:10.6.7-1 aarch64
marisa-static/stable 0.2.6 aarch64
marisa/stable 0.2.6 aarch64
proxmark3-git/stable 2022.06.27-636a8501-0 aarch64
proxmark3/stable 1:4.14831-2 aarch64
安装
~ $ pkg install mariadb
Testing the available mirrors:
[*] (1) https://mirrors.hit.edu.cn/termux/apt/termux-main: ok
[*] (1) https://mirrors.dgut.edu.cn/termux/apt/termux-main: bad
[*] (1) https://mirrors.nju.edu.cn/termux/apt/termux-main: ok
[*] (1) https://mirrors.cqupt.edu.cn/termux/apt/termux-main: ok
[*] (1) https://mirrors.aliyun.com/termux/termux-packages-24: ok
[*] (1) https://mirrors.bfsu.edu.cn/termux/apt/termux-main: ok
[*] (1) https://mirrors.pku.edu.cn/termux/termux-main/: ok
[*] (1) https://mirrors.ustc.edu.cn/termux/apt/termux-main: ok
[*] (1) https://mirror.iscas.ac.cn/termux/apt/termux-main: ok
[*] (1) https://mirrors.tuna.tsinghua.edu.cn/termux/apt/termux-main: ok
Picking mirror: (6) /data/data/com.termux/files/usr/etc/termux/chosen_mirrors/mirrors.ustc.edu.cn
Get:1 https://mirrors.ustc.edu.cn/termux/apt/termux-main stable InRelease [14.0 kB]
Get:2 https://mirrors.ustc.edu.cn/termux/apt/termux-main stable/main aarch64 Packages [429 kB]
Fetched 443 kB in 2s (209 kB/s)
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
All packages are up to date.
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following NEW packages will be installed:
mariadb
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 11.4 MB of archives.
After this operation, 159 MB of additional disk space will be used.
Get:1 https://mirrors.ustc.edu.cn/termux/apt/termux-main stable/main aarch64 mariadb aarch64 2:10.6.7-1 [11.4 MB]
Fetched 11.4 MB in 2s (6075 kB/s)
Selecting previously unselected package mariadb.
(Reading database ... 25304 files and directories currently installed.)
Preparing to unpack .../mariadb_2%3a10.6.7-1_aarch64.deb ...
Unpacking mariadb (2:10.6.7-1) ...
Setting up mariadb (2:10.6.7-1) ...
Initializing mysql data directory...
Installing MariaDB/MySQL system tables in '/data/data/com.termux/files/usr/var/lib/mysql' ...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is u0_a340@localhost, it has no password either, but
you need to be the system 'u0_a340' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '/data/data/com.termux/files/usr' ; /data/data/com.termux/files/usr/bin/mysqld_safe --datadir='/data/data/com.termux/files/usr/var/lib/mysql'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/data/data/com.termux/files/usr/mysql-test' ; perl mysql-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
客户端连接
mysql
# 创建用户
MariaDB [mysql]> create user 'root'@'%' identified by 'Q7.123';
Query OK, 0 rows affected (0.009 sec)
# 设置权限
MariaDB [mysql]> grant all privileges on *.* to 'root'@'%' identified by 'Q7.123';
修改密码(可选)
SET PASSWORD FOR 'u0_a340'@'localhost' = PASSWORD('Q7.123');
启动服务
加入到 ~/.bashrc
文件
# --------------- mysqld ----------------------
name='mysql'
if pgrep -x "mysqld_safe" >/dev/null
then
echo "[${name}]运行中..."
else
cd '/data/data/com.termux/files/usr' ; /data/data/com.termux/files/usr/bin/mysqld_safe --datadir='/data/data/com.termux/files/usr/var/lib/mysql' >/dev/null 2>&1 &
echo "[${name}]启动..."
fi
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 推荐几款开源且免费的 .NET MAUI 组件库
· 实操Deepseek接入个人知识库
· 易语言 —— 开山篇
· Trae初体验
2020-07-17 Java实现几种常见排序方法
2020-07-17 Docker openjdk-8-jdk-alpine 容器时间与jdk时区不同修改方法