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… 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
