I'm Mac user and I've recently installed MySQL CLI with Homebrew :
brew install mysql-client
Most of time I use it for classic connection on default MySQL port :
mysql -h hostname -P 3306 -uuser -p
And it works great !
Now I need to use it to connect on specific port :
mysql -h hostname -P 44000 -uuser -p
And I get the following message :
ERROR 1045 (28000): Access denied for user 'root'@'ip' (using password: NO)
I've tried with passing password in clear or using a config file but I got the same message. It seems that password isn't send when a port other than default is used.
Anyone has already encountered this problem and know how to solve it please ?