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/[EMAIL PROTECTED]
