From: Héctor S. Mendoza O. (hectoracorporativa.com.mx)
Date: Mon Jul 09 2007 - 16:33:04 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

The problem persists, with /usr/bin/mysql or with a php application, same
sympthoms

TIA

Hector

-----Mensaje original-----
De: Gerald L. Clark [mailto:gerald_clarksuppliersystems.com]
Enviado el: Lunes, 09 de Julio de 2007 02:54 p.m.
Para: "Héctor S. Mendoza O."
CC: mysqllists.mysql.com
Asunto: Re: error in login

Héctor S. Mendoza O. wrote:
> Hello all… I’ve 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.
>
>
>
> I’ve tried removing the ‘localhost’ from the user and only leaving ‘%’
with
> no difference at all. I’ve 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/mysql?unsub=hectoracorporativa.com.mx

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]