I've been dealing with this problem for a week now
I'm running an application called mythtv which uses
mysql as its database.
I've installed mythtv and mysql dozens of times
without any problem.
I'd been running two Mandrake 10.1 systems for the
last nine months. One,
gandalf, was the mythtv backend server which also runs
mysql. The other is
frodo, which runs the mythtfrontend ( client ) and
connects to the backend.
It must also connect to the mysql DB.
MySQL-4.0.20-3mdk.i586.rpm comes with
the Mandrake 10.1 distribution. I don't know which
version of mysql that
I first installed Mandrivia 2006 on the client system,
which comes with
Mysql 4.1.2 ( MySQL-4.1.12-3mdk.i586.rpm ). I did an
install, not an
upgrade. I could still connect to gandalf with:
mysql -umythtv -pmythtv -hgandalf mythconverg
I then did a mysqldump on mythconverg and install
Mandrivia 2006 on
server gandalf. I restored the mythconverg; Now, I
[root@frodo# mysql -u mythtv -pmythtv -h gandalf
ERROR 2003 (HY000): Can't connect to MySQL server on
I then tried granting privledges to mythconverg using
on the server
# mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%"
identified by "mythtv";
mysql> flush privileges;
Still can't connect.
I booted off the old installation and did a mysql dump
of mysql database
and did inserts of the appropriate tables, like the
user table. Still
I've droped the mythconverg database, recreated a
skeleton of it, granted
the open privledges and still can not connect to it.
Another fact: on the server gandalf, I can connect
to the database
as localhost, but not if I specify the host:
gandalf# mysql -u mythtv -pmythtv mythconverg
gandalf# mysql -u mythtv -pmythtv -h gandalf
gandalf# mysql -u mythtv -pmythtv -h 10.0.1.40
gandalf# mysql -u mythtv -pmythtv -h 127.0.0.1
gandalf# mysql -u mythtv -pmythtv -h localhost
I've already check my /etc/my.cnf file for a "binding"
line. Its not
there. I also found an item online that indicated
to /etc/my.cnf was needed for mysql under Mandrake.
Still no help.
Also, I can resolve the name/ip of both hosts from
both hosts. I
can ping each host ( by name ) both ways. I can ssy (
by name ) between
Start your day with Yahoo! - Make it your home page!