The problem persists, with /usr/bin/mysql or with a php application, same sympthoms
TIA Hector -----Mensaje original----- De: Gerald L. Clark [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 09 de Julio de 2007 02:54 p.m. Para: "Héctor S. Mendoza O." CC: [email protected] Asunto: Re: error in login Héctor S. Mendoza O. wrote: > 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 > > > > > > Use a my.cnf file in the user's home directory. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
