Hello all Ive scratched my head for a while on this one, so if someone could shed some Light on it I would appreciate it very much
I have an account setup, and know about the password settings regarding hosts. The account is named web19_u1, and has listed % and localhost as posible hosts to be able to log in On remote machines I do a mysql -u web19_u1 -p -h10.10.10.2 p web19_db1 and have no problems on querying the tables On the local host (where the mysqld resides) I do the same command and get a ERROR 1045 (28000): Access denied for user 'web19_u1'@'db1.intranet' (using password: YES). If I change this to hlocalhost I can login correctly. My problem is that the application (php based) resides both on local intranet and in internet (two different servers), remote machine is in intranet and needs ip 10.10.10.2 to access database, and local host (mysqld resides in) can only use localhost. Development and testing of application is done in intranet so basically I need two different configuration files depending on where the application is running to access the database. Ive tried removing the localhost from the user and only leaving % with no difference at all. Ive also tried the protocol=TCP option with no luck either. Any pointers? TIA Hector S. Mendoza O PS. mysqld Ver 5.0.27
