Another thought is to turn on logging on the mysql server, and see if
the requests are coming through and being denied, or if they are not
even reaching the server.
A.
On Jul 14, 2005, at 4:58, Philipp Rossmanith wrote:
hi,
did you do a fresh install of the mysql server? then, you should
hi,
did you do a fresh install of the mysql server? then, you should check
the configuration file, my.cnf. by default, mysql disallows remote
connections.
you can read more here:
http://www.webmasterworld.com/forum10/6141.htm
hope it helps.
ciao, philipp
Derek Hohls wrote:
Upayavira
This
Firewall may be blocking port 3306.
You might also want to try using the MySQL query tool or administration
tool to see if they can access the database over the network.
Ron
Upayavira wrote:
Could be that you need to grant authorisation by machine name not by
IP. I've had struggles with tha
Derek Hohls wrote:
Quick follow-up.
I check with the admin staff and the mysql client had been
installed and so was able to test the permissions as per
your guidelines - that worked and I was also able to run
my query OK.
So I figured there must be a problem with the Cocoon
setup... somewh
Quick follow-up.
I check with the admin staff and the mysql client had been
installed and so was able to test the permissions as per
your guidelines - that worked and I was also able to run
my query OK.
So I figured there must be a problem with the Cocoon
setup... somewhere. I went back to t
Upayavira
This makes sense, except for the "mysql client" part.
My MachineB is the equivalent of your Windows (except
it runs Linux, but I assume that makes no difference);
and my MachineA is the equivalent of your chandra (and
also running mysql).
The only difference is that there is not a "
I have Mysql running on Linux, on host Chandra.
I have the mysql client running on windows, host creatively named win2k.
If I log onto win2k and run:
mysql -uroot -ppasswd -h chandra
I get: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
So, I logged onto chandra and did:
g
Uh - if I try:
./mysql -u myname -ppasswd -h machineB.com
that gives me the error:
Access denied for user "machineA.com"
(machine A is where I have telnetted into [from MachineB]
... and is also where the database is located - this is in line
with the manual which states:
"If mysql -u root te
Derek Hohls wrote:
Upayavira
Thanks for the heads-up.
I have now tried using the machine name as well... but with no
success.
Re the second approach - this is not clear to me. I would normally
telnet into the box, then run ./mysql -u myname -p to work with
sql. However, my understanding is t
Upayavira
Thanks for the heads-up.
I have now tried using the machine name as well... but with no
success.
Re the second approach - this is not clear to me. I would normally
telnet into the box, then run ./mysql -u myname -p to work with
sql. However, my understanding is that when I do this I
Could be that you need to grant authorisation by machine name not by IP.
I've had struggles with that sort of thing before.
Best to debug this by trying to login to remote host just using the
mysql command at the command line. Then, once you've got that working,
you can scale up to doing it wi
I am struggling with getting a new server to communicate with a mySQL database
on another machine.
The database and queries work fine, when running on machine A, where the
database is installed,
as does the Cocoon application when running there.
However, when I try and emulate the Cocoon appl
12 matches
Mail list logo
