Topic: Using MySQL for My Projects

[Gary Chernipeski]

I can add databases to the MySQL install, but when trying to connect to them, the server appears to automatically disconnect me almost immediately.

Bug or Feature?

[Prezes]

No-one seems to be replying to this thread, so I'll put forward my question (and as I'm new to lynux.....)

Are you sure you are actually connecting to the DB????
How are you connecting to it??? PHP??? or what???

[Gary Chernipeski]

The error you get is the same as a time-out, but its instantaneous, as if MySQL under e-smith is ignoring the time-out setting.  

I wonder if this is on purpose -- as in the e-smith team didn't want these things used as SQL servers?  (I found a thread somewhere to that effect).  If so, just post that fact to this thread so I can wipe e-smith off one of my servers (reluctantly) and get on with life...

[Prezes]

Well,

The only thin I can say is renstall (as I'm new to lynux).

I'm running 5.6 and don't have any problems with MySQL

[Gary Chernipeski]

Sorry didn't really answer your question, connecting to it from Windows box using the MySQL ODBC connector (the goal), but during testing also used the MySQL Control Center with the exact same connect error.

[SLIM on SCOTT09] ERROR 2013: Lost connection to MySQL server during query

Here is a "real" connect error.

[SLIM on SCOTT02] ERROR 2003: Can't connect to MySQL server on '10.0.0.202' (10061)

[Prezes]

You can check if your SQL server is actually running by trying to execute the script on the server it self. If that works, the it seems to me that you don't have the stting enable to allow remote connections