安装带有自动补全功能的MySQL客户端——mycli
安装python3(python2.7已经被弃用)
[root@zabbix-server ~]# yum -y install python3
安装mycli
[root@zabbix-server ~]# pip3 install mycli
用mycli登录数据库
[root@zabbix-server ~]# mycli -uroot -p123
mariadb 5.5.68-MariaDB
mycli 1.22.2
Chat: https://gitter.im/dbcli/mycli
Mail: https://groups.google.com/forum/#!forum/mycli-users
Home: http://mycli.net
Thanks to the contributor - Dick Marinus
mariadb root@localhost:(none)>
使用-p参数必须将密码打在屏幕上,会带来一些安全隐患,使用下面的方式登录可以不显示密码
[root@zabbix-server ~]# mycli -uroot
Password:
mariadb 5.5.68-MariaDB
mycli 1.22.2
Chat: https://gitter.im/dbcli/mycli
Mail: https://groups.google.com/forum/#!forum/mycli-users
Home: http://mycli.net
Thanks to the contributor - Zhaolong Zhu
mariadb root@localhost:(none)>
效果如图