MySQL: problem when connecting some hosts

I have a problem with connecting mysql on our main db server with other hosts we run.

NOTE: The problem does appear now while we have had to migrate our networks and IP addresses, presumably caused (or evidenced) by this migration.

Migration context: most of our machines have been migrated to (ip.1 on eth0) to (ip.2 on eth0, ip.1 on eth0:0)
This seems to have gone OK, but now I must remove the eth0:0, and some problem do appear. Most presumably some problems of the db machine being aware of its 2 IPs, and allowing connection from the outside only on its old eth0:0
Error message 1:
The mysqli error was: Can't connect to MySQL server on 'xxx.fr' (110).

Open in new window

Error message 2:
#2003 - Can't connect to MySQL server on 'xxx.fr' (110)

Open in new window


- I have disabled IPTables filtering and denyhosts
- I have commented the line bind-address      in my.cnf
- etc

All suggestions and ideas are welcome.
How can I find or trace the blocked incoming connexions? nothing appears  in the usual logs..
LVL 29
Bernard S.CTOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bernard S.CTOAuthor Commented:
Found the problem: /etc/hosts/ both on the db machine and on the other sites were outdated and pointed to old addresses... which I had not removed at the same time.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bernard S.CTOAuthor Commented:
Having all network addresses change at the same time is really a nightmare!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.