hello all,
When I send : mysql -h address -u root -p from a distant computer I don't
get connected. I think it is a timeout problem.
How can I increase the timeout period.
TIA
mosaed
If you do not connect probably you have a firewall in between,
and it is not a timeout problem.
You should ask your network administrators to open, if possible, that port
for you.
Another option is to ssh to the host and do a local connection to the MySQL
instance.
Cheers
Claudio Nanni
First, be sure you can access the host - try pinging it.
Second, if you can ping the computer so you know there's no network issue,
be sure you've got the mysql permissions to connect from that host to either
the server or the database (if you specify one). You may have permission to
connect
from a purely network point of view PING works if ICMP traffic is allowed
do a tracert and find out which intervening node is rerouting the traffic
you might have something funky on the routing tables
Martin
__
Disclaimer and confidentiality note
b wrote:
I'm having some difficulty getting my head around a particular query.
I'd like to make this a view once I get something working. However, all
I've been able to come up with uses a sub-query. So, no view on the
horizon.
I have 3 tables:
users
id,
(etc. the usual)
disciplines
I updated from MySQL 5.01 to 5.1 a few days ago. My Delphi application runs
on XP with 3GB ram.
I have a query #1 that executes a simple Select statement that fetches 5000
rows from a single table sorted by date. (no joins)
Inside a loop if any rows need to be updated, another query #2 will