Larry Martell logging in using host alias not working
Apr 18, 2013; 10:59
Larry Martell
logging in using host alias not working
We use host aliases to connect to MySQL all the time, never had an issue before. Today we added a new alias, and we cannot connect to the server using that one alias but only when we are on the local machine.
I can connect from all these aliases, except intradb-test-dr when I am on ubshp2, e.g.:
From ubshp2 using the intradb-us-dev alias, works:
ti-test-dr@ubshp2: mysql -h intradb-us-dev -u tradeinfra -pXXXX intradb_test_dr Welcome to the MySQL monitor. Commands end with ; or \g.
From ubshp2 using the intradb-au-qa alias, works:
ti-test-dr@ubshp2: mysql -h intradb-au-qa -u tradeinfra -pXXXX intradb_test_dr Welcome to the MySQL monitor. Commands end with ; or \g.
From ubshp2 using the intradb-test-dr alias, does not work:
ti-test-dr@ubshp2: mysql -h intradb-test-dr -u tradeinfra -pXXXX intradb_test_dr ERROR 1045 (28000): Access denied for user 'tradeinfra'@'ubshp2.predict.com' (using password: YES)
But from a different host using the intradb-test-dr alias, works:
ti-test-dr@hades: mysql -h intradb-test-dr -u tradeinfra -pXXXX intradb_test_dr Welcome to the MySQL monitor. Commands end with ; or \g.
Anyone have any ideas as to why this one is not working? I've been messing with this for 2 days. Nothing in the error log. I've dropped and re-added the user, I've bounced the server, I've removed and re-added the alias. I've googled and googled and found nothing.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Apr 18
Larry Martell Re: logging in using host alias not working
Apr 18, 2013; 11:07
Larry Martell
Re: logging in using host alias not working
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!