Problem connecting to external mysql database -
my problem command produces error when tried connect our server external server : mysql -h db.hostname.com -u username -pp@ssword database_name and error : error 1044 (42000): access denied user 'username'@'%' database 'database_name' i asked external server admin add our ip in firewall no avail.. has granting privileges 'username' it's not problem firewall, since mysql is denying connection. suspect, problem privileges granted user. need execute on mysql server (you might need tweak bit if don't want grant privileges db): grant on database_name.* 'username'@'%' identified 'p@ssword'; also note if connect specific host/ip, it's better idea specify host/ip, instead of using wildcard % , allow connections anywhere.