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
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 …[Read more]