MySQL数据库自动补全命令

方式一:临时使用自动补全功能

mysql -u root -p --auto-rehash


方式二:永久使用自动补全功能

vim  /etc/my.cnf

[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 https://www.python.org/ftp/python/3.9.0/Python-3.9.0.tgz


mkdir ~/.pip/


cat > ~/.pip/pip.conf <<EOF

[global]

index-url = https://mirrors.aliyun.com/pypi/simple/


[install]

trusted-host=mirrors.aliyun.com

EOF


yum -y install libffi-devel zlib* python-devel openssl-devel

tar -zxf Python-3.9.0.tgz

cd Python-3.9.0/

./configure --prefix=/usr/local/python --with-ssl

make && make install 


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


评论者:[[ schemeInfo.user.username ]]

评论内容:[[ schemeInfo.pbody ]]

评论时间:[[ schemeInfo.ptime ]]





发表你的评论:

提交评论
上一篇:
下一篇: