Gracias Carlos, I've tried that already with no results, I've left only the [EMAIL PROTECTED] and have no luck logging in from the same machine the mysqld is running, I can log in perfectly from anywhere.
TIA Hector S. Mendoza O -----Mensaje original----- De: Carlos Proal [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 09 de Julio de 2007 04:50 p.m. CC: [email protected] Asunto: Re: error in login Hola Hector, el problema son las 2 tuplas que mencionas, ya que debido a su jerarquia pueden hacer un conflicto que te evita conectarte correctamente, en tu caso si deseas que el usuario se conecte desde donde sea (%) elimina la tupla de la tabla user donde aparezca el localhost, esto puede ser en la table user o en la tabla db de la base de datos mysql. Hector, the problem is maybe that you have 2 rows granting permissions to this user and is possible that due to hierarchies or precedence one overrides each other. I suggest to eliminate the "localhost" entry and leave the % because anyways you are allowing this user to connect from anywhere including the localhost. This problem can be on the user or db tables of the mysql database. Carlos Héctor S. Mendoza O. wrote: > 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. > > -- 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]
