Git Bash mysql blank

I've installed Git (bash?) from www.git-scm.com I also have a working installation of MySQL. I'm using windows 8.1. The path to my mysql bin directory IS in my path environment variable, and the mysql service IS running.

If i open cmd.exe and type in mysql -u root then it logs me in successfully, I get the "welcome to mysql monitor" message, and i can start typing sql away.

However in Git bash, if I type in mysql -u root then it just starts a new blank link and doesn't do anything.

If i type in mysql -? then i still get the mysql help information. If i type in mysql start, I get the Access denied for user ''@'localhost' to database 'start'.

How can I access mysql properly in git bash?

Please see my crude image explaining my situation below:

Solution 1:

I had the same problem with git bash and mysql, and solution to this is to use

winpty mysql -u root

I guess this is because you are running mysql for windows, using unix environment, and as far as I know winpty should be used for running windows applications in the git bash (not 100% sure, maybe someone can confirm).

Solution 2:

A Quick fix for other users facing that issue too:

You can create a .bash_profile to config git bash, to always use winpty by default :

cd ~ && echo "alias mysql=\"winpty mysql\"" > .bash_profile

if you already have a .bash_profile in your user folder use this command instead:

cd ~ && echo "alias mysql=\"winpty mysql\"" >> .bash_profile

Solution 3:

Create a shortcut in Windows Desktop with this destination:

"C:\Program Files\Git\usr\bin\mintty.exe" -e "C:\Program Files\Git\usr\bin\winpty.exe" "C:\Program Files (x86)\MariaDB 10.1\bin\mysql.exe" -uroot -p