Alias shortcuts to MySQL CLI
Do you get write laziness in the command line everything what you need to connect to a MySQL server every time?
It may take less than minute, but sometimes one minute is vital (especially if we’re near the end of the world):
ivancp@ubuntu$ mysql -u root -p -h mysqlhost database
When we are hurry, these commands often fail several times per minute.
The solution: we can create shortcuts with bash alias commands in file ~/.bashrc :
# File ~ /. Bashrc # Command "my" to connect to a local server alias my='mysql -u root -p' # Command "my2" to connect to a remote server alias my2='mysql -u root -h 192.168.1.56 -p'
Next time if you want to access the local server just type the command
my [database name] , there only ask for database password. You can use any command aliases, I prefer “my” and “my2″ they are short and useful.
But if you have several servers comes another problem, how to know in which server I’m?
Open a mysql-cli can be super fast with alias shortcuts, but all terminals have the same default prompt:
mysql> To avoid disasters (ex. run DROP in wrong place) you can change mysql-cli prompt with option
--prompt , then finally our .bashrc look like this:
#improved ~/.bashrc # Command "my" to connect to a local server alias my='mysql -u root --password=secret --prompt="local> "' # Command "my2" to connect to a remote server alias my2='mysql -u root --password=secret -h 192.168.1.56 --prompt="server 1> "'
Note I added
--password parameter, it can be dangerous, use it under your own risk.