MySQL数据库⾃动补全命令的三种⽅法
注意:第三种⽅法要在 XSell 中使⽤,在 finalsell 中使⽤不了
⽅式⼀:临时使⽤⾃动补全功能
mysql -u root -p --auto-rehash
⽅式⼆:永久使⽤⾃动补全功能
vim /etc/myf
[mysql]
auto-rehash
⽅式三:使⽤软件mycli实现⾃动补全功能
此⽅法需要使⽤在线源进⾏软件包的安装
yum -y install epel-release
yum -y install python-pip
yum -y install python-devel
yum clean all
yum -y install gcc libffi-devel openssl-devel && pip install --ignore-installed mycli==1.8.0
yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel gcc wget /ftp/python/3.9.0/Python-3.
mkdir ~/.pip/
cat > ~/.f <<EOF
[global]
index-url = mirrors.aliyun/pypi/simple/
[install]
trusted-host=mirrors.aliyun
EOF
yum -y install libffi-devel zlib* python-devel openssl-devel
tar -zxf Python-3.
cd Python-3.9.0/
./configure --prefix=/usr/local/python --with-ssl
make && make install
python安装教程非常详细ln -s /usr/local/python/bin/python3 /usr/bin/
echo 'export PATH=/usr/local/python/bin:$PATH' >> /etc/profile
source /etc/profile
pip3 install mycli
mycli
到此这篇关于MySQL数据库⾃动补全命令的三种⽅法的⽂章就介绍到这了,更多相关MySQL ⾃动补全命令内容请搜索以前的⽂章或继续浏览下⾯的相关⽂章希望⼤家以后多多⽀持!

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。