Intro
You might be using following command as a workaround in your local environment for avoiding setting a mysql password
sudo mysql
But, what if you want to use mycli
.
Note: if you just use sudo pip install <some_package_name>
This might break the system, as python dependencies of the system may get affected.
How to enable mycli
Switch to root account
sudo su
Create a virtualenv in root user's home folder (or where ever you like :-) )
python -m venv /root/venv
Add this venv to load by default in root account.
vim ~/.bashrc
# Add this conent
. /root/venv/bin/activate
Now you can use
sudo mycli
Note
Just use pip install command to install similar tools like pgcli too samve venv (ie. /root/venv). But, pgcli doesn't support this root login, as far I know.
pip install pgcli
Top comments (0)