Place in ~/.bash_login, ~/.bash_profile, or ~/.bashrc after changing lines 2 and 3:
my() {
user="your_username";
pass="your_password";
if [ $# = 1 ]
then
mysql -u $user --password=$pass $1;
else
mysql -u $user --password=$pass --execute='show databases';
mysql -u $user --password=$pass;
fi
}
Pop out
1 2 3 4 5 6 7 8 9 10 11 | my() { user="your_username"; pass="your_password"; if [ $# = 1 ] then mysql -u $user --password=$pass $1; else mysql -u $user --password=$pass --execute='show databases'; mysql -u $user --password=$pass; fi } |
Before:
mysql -u [user] -p ([database])
Pop out
$ | mysql -u [user] -p ([database]) |
Enter password: mysql >
After:
my ([database])
Pop out
$ | my ([database]) |
mysql >