Linux 以及 Mysql 配色

客官°小女子只卖身不卖艺 2022-10-09 05:59 4阅读 0赞

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70][]

是否厌倦了 Linux 系统 以及 Mysql 千篇一律的 mysql> ？改变一下提示符以及显示颜色吧~

*  下载 grc
 *  **git clone https://ghproxy.com/https://github.com/garabik/grc.git**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 1][]

*  cd grc/
 *  bash install.sh

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 2][]

*  下载 [colour-mysql-console][]
 *  **git clone https://ghproxy.com/**[https://github.com/nitso/colour-mysql-console][colour-mysql-console]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 3][]

*  复制 .grcat .my.cnf 文件到用户（root）家目录

![20210624100703323.png][]

*  安装 rlwrap
 *  yum -y install rlwrap
 *  vim .bashrc  在末尾添加以下内容

if \[\[ -f /usr/local/bin/grc \]\]; then  
alias ping="grc --colour=auto ping"  
alias traceroute="grc --colour=auto traceroute"  
alias make="grc --colour=auto make"  
alias diff="grc --colour=auto diff"  
alias netstat="grc --colour=auto netstat"  
alias df="grc --colour=auto df -Th"  
alias ps="grc --colour=auto ps"  
alias dnf="grc --colour=auto dnf"  
alias id="grc --colour=auto id"  
alias ip="grc --colour=auto ip"  
alias du="grc --colour=auto du"  
alias ss="grc --colour=auto ss"  
alias systemctl="grc --colour=auto systemctl"  
alias ifconfig="grc --colour=auto ifconfig"  
alias mount="grc --colour=auto mount"  
fi  
if \[\[ -f /usr/bin/rlwrap \]\]; then  
alias mysql='rlwrap -a -p'GREEN' mysql --prompt="\[\\U \\d\]> "'  
fi  
export PATH=/usr/local/bin:/usr/local/sbin:$PATH

*  其他支持 grc 颜色的命令

![20210624101118327.png][]

*  . .bashrc

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 4][]

![20210624101257717.png][]

*  ### **安装 mycli 有命令补全功能** ###
 *  官方网站 [https://www.mycli.net/][https_www.mycli.net]
 *  支持 mysql mariadb
 *  安装使用mycli 1.20+需要 python3.6+
 *  如果 python <= 2.6 
    
        pip install mycli==1.8.1

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 6][]

*  安装 依赖包
 *  yum install postgresql-devel python3-devel -y
 *  pip3 install --upgrade pip
 *  pip3 install -U setuptools\_rust
    
    pip3 install -U mycli

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 7][]

*  使用 mycli
 *  mycli -uroot -p123456
 *  tab 可以补全命令

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 8][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 9][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 10][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 11][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70]: /images/20221005/294f707bca7e4e309ec2de22078b946d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 1]: /images/20221005/4ca14adde2754a5f9f2be36fd5d5f50a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 2]: /images/20221005/fbfbfdd194864a9c94e9fc662fe4e000.png
[colour-mysql-console]: https://github.com/nitso/colour-mysql-console
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 3]: /images/20221005/d3faab5768cf4fdba83b43f9b2656d15.png
[20210624100703323.png]: /images/20221005/2c4c758df3d44349933329bfc978080f.png
[20210624101118327.png]: /images/20221005/c921636fa8e44927971ed49ce94ede2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 4]: /images/20221005/dc5923fe0b1f4d758a956396c44c04ea.png
[20210624101257717.png]: /images/20221005/7a208f69ab5f4708a499629d64aec23a.png
[https_www.mycli.net]: https://www.mycli.net/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 5]: /images/20221005/5a7b7f6b0d8d42af8bfe4c2c1d2a98fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 6]: /images/20221005/69ba389e6c6d41fda7362b26ac4ff18a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 7]: /images/20221005/b6a61c17f4244ea0b068e5621ece8c0b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 8]: /images/20221005/1dd3b3206bfc49cdbe0d5b82d8a80500.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 9]: /images/20221005/a3b1f9e169bd429b8f996961b0312afb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 10]: /images/20221005/adcd555ea76c404dae71a813886921a9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dhb2ZlaTA0Mjg_size_16_color_FFFFFF_t_70 11]: /images/20221005/e6e2c966a3394b3c838f5a7a397af6d7.png