When working with Databases i use DbDesigner, since it is a free tool and is working great although they have stopped working on it a long time ago. The whole development team is working for MySQL now and are working on MySQL Workbench, but there is only an alpha yet.
So the only open source solution is still DbDesigner..
A couple of days ago i come up with a big problem .. DbDesigner on my PC was not able to connect to my Servers Database... i was looking over an over again and found the Problem...
Since i am using Debian, my MySQL Version was updatet a couple of times now and now there is a new adjustment in the my.cnf File called bind-address.
If you use:
bind-address 127.0.0.1
only the localhost can access the database. Since i am using a Server behind a FireWall and only for development purpose i just had to disable the Line and now everything is working again.
Thanx for this tipp to a good friend of mine ;-)
No comments:
Post a Comment