mysql-go

为什么有这个轮子

在维护服务器时，一般需要进行 mysql 连接相关的测试，有的没有安装 mysql, 安装官方的 mysql 太麻烦，我想一个文件能搞定，无库文件依赖，全静态编译的单文件
mysql 官方的命令行客户端没有静态编译的版本(网上也没找到) (如果能提供类似需求的功能完善的轮子更好)
一般紧急临时用，mysql 官方的命令行客户端体积很大，几百 M
日常管理还是建议使用 navicate 之类的客户端

仓库地址

https://github.com/xxoxx/mysql-go/

Feature

类似 linux 下的 grep,这样在管理过程中就少写一些 where,like 等

mysql> show variables; | grep log_bin
Variable_name   Value
log_bin ON
log_bin_basename        /var/lib/mysql/binlog
log_bin_index   /var/lib/mysql/binlog.index
log_bin_trust_function_creators OFF
log_bin_use_v1_row_events       OFF
sql_log_bin     ON
6 rows in set (0.01 sec)

mysql> show variables; | grep binlog

类似 linux 下的 grep -v 排除过滤

mysql> show processlist; | grepv sleep
Id      User    Host    db      Command Time    State   Info
5       event_scheduler localhost       NULL    Daemon  1902954 Waiting on empty queue  NULL
115     root    192.168.3.101:63598     NULL    Query   0       init    show processlist
2 rows in set (0.00 sec)

使用例子基本跟官方的用法一至

mysql -uroot -p123456 -h127.0.0.1 -P3306
mysql -u root -p 123456 -h 127.0.0.1 -P 3306
mysql -uroot -p123456 -h127.0.0.1 -P3306 -Ddbname
mysql -uroot -p123456 -h127.0.0.1 -P3306 -f xxx.sql
mysql -uroot -p123456 -h127.0.0.1 -P3306 -Ddbname < xxx.sql
mysql -uroot -p123456 -h127.0.0.1 -P3306 -Ddbname -e 'select * from users limit 10;'

安装

wget https://gitee.com/tinatmp/mysql/releases/download/mysql/mysql_linux -O /usr/local/bin/mysql  chmod +x /usr/local/bin/mysql

其它

兼容 mysql5.7 mysql8 tidb
测试不全，可能存在 bug

nilai

284 天前

@superchijinpeng 不可否认，mysqlsh 是一个非常强大的命令行工具，它是用来准备替换 mysql 的，它支持 python js 两种引擎，它为 mgr 集群主从同步提供了非常便利的操作，我也一样在用它，但是安装它稍微要麻烦一点点，需要解压到目录，以及设置环境变量，另外，mysqlsh 并不是完全的无依赖，不信请看
root@cdfea3ff6ac5:/opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit# ls /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit
bin lib libexec share
root@cdfea3ff6ac5:/opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit# ldd /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/mysqlsh
linux-vdso.so.1 (0x00007fff30ea2000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f19e2d3d000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f19e2d38000)
libcrypto.so.3 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libcrypto.so.3 (0x00007f19e2600000)
libssl.so.3 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libssl.so.3 (0x00007f19e2200000)
libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f19e2d27000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f19e2d20000)
libssh.so.4 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libssh.so.4 (0x00007f19e1e00000)
libutil.so.1 => /lib/x86_64-linux-gnu/libutil.so.1 (0x00007f19e2d1b000)
libpython3.10.so.1.0 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libpython3.10.so.1.0 (0x00007f19e1800000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f19e2c3c000)
libantlr4-runtime.so.4.10.1 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libantlr4-runtime.so.4.10.1 (0x00007f19e1400000)
libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f19e11e6000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f19e2c1a000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f19e1005000)
/lib64/ld-linux-x86-64.so.2 (0x00007f19e2d46000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f19e2bfb000)
libgssapi_krb5.so.2 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libgssapi_krb5.so.2 (0x00007f19e0c00000)
libkrb5.so.3 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libkrb5.so.3 (0x00007f19e0800000)
libk5crypto.so.3 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libk5crypto.so.3 (0x00007f19e0400000)
libcom_err.so.3 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libcom_err.so.3 (0x00007f19e0000000)
libuuid.so.1 => /lib/x86_64-linux-gnu/libuuid.so.1 (0x00007f19e25f4000)
libkrb5support.so.0 => /opt/test/mysql-shell-8.0.36-linux-glibc2.12-x86-64bit/bin/../lib/mysqlsh/libkrb5support.so.0 (0x00007f19dfc00000)
libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f19e25eb000)

我造了个轮子,mysql 命令行的客户端

mysql-go

为什么有这个轮子

仓库地址

Feature

使用例子 基本跟官方的用法一至

安装

其它

使用例子基本跟官方的用法一至