Correctlysettingyourmysqlpromptusingsudo_MySQL

来源：懂视网责编：小采时间：2020-11-09 19:18:51

Correctlysettingyourmysqlpromptusingsudo_MySQL

Correctlysettingyourmysqlpromptusingsudo_MySQL:If you run multiple MySQL environments on multiple servers its a good habit to set your MySQL prompt to double check which server you are on.however, using the MYSQL_PS1 environm

推荐度：

点击下载本文 文档为doc格式

导读Correctlysettingyourmysqlpromptusingsudo_MySQL:If you run multiple MySQL environments on multiple servers its a good habit to set your MySQL prompt to double check which server you are on.however, using the MYSQL_PS1 environm

If you run multiple MySQL environments on multiple servers it’s a good habit to set your MySQL prompt to double check which server you are on.
however, using the MYSQL_PS1 environment variable I found this does not work under sudo (the normal way people run sudo).

I.e., the following syntax’s work.

$ mysql$ sudo su - -c mysql$ sudo su - ; mysql

but the following does not.

$ sudo mysql

The trick is actually to ensure via /etc/sudoers you inherit the MySQL_PS1 environment variable.

echo "export MYSQL_PS1=/"`hostname` [/d]> /"" | sudo tee /etc/profile.d/mysql.shecho 'Defaultsenv_keep += "MYSQL_PS1"' | sudo tee /tmp/mysqlsudo chmod 400 /tmp/mysqlsudo mv /tmp/mysql /etc/sudoers.d

Tags:mysql client,mysql prompt,MYSQL_PS1,sudo

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

Correctlysettingyourmysqlpromptusingsudo_MySQL

推荐度：

点击下载本文 文档为doc格式

标签： mysql your setting

热门焦点

Correctlysettingyourmysqlpromptusingsudo_MySQL

Correctlysettingyourmysqlpromptusingsudo_MySQL

Correctlysettingyourmysqlpromptusingsudo_MySQL

最新推荐

猜你喜欢

热门推荐