MySQL5 client access to ISPConfig box vs plain centos5
I have ispconfig box which setup properly according Centos 5 Perfect Server Setup (has Mysql 5 in it) then I install ispconfig on it. and I have another box which I am only install mysql 5 also using Centos 5 (for test dbserver). here's is my problem:
I have user who still using old 2002 mysql-front (which I assumed still using libmysql library from mysql 3.23), he can access to mysql dbs at ispconfig box without problem, but then when tried to connect to test dbserver he can't.
error shows up:
when I am installing Centos 5 perfect server + ispconfig, i didn't notice some configuration / installing other packages for mysql which may required by ispconfig.
so please can you tell me, what do I miss on my plain Centos5 with mysql5 box? why I can't accessing it using the same program (mysql-front) which I can use it to another server running ispconfig (centos5 with mysql5) :confused:
thank you in advance for your time to take reply
oke case closed, I have found the answer,
after I change /etc/my.cnf on test-dbserver with
but then it brings up a question. Mysql 5 already support stored procedure, views, sub-select etc, etc, which not available when mysql 3.23, can my old programs or dll which still using mysql 3.23 library take those advantages? I mean using sub-select, insert-select and perhaps read views table or running stored procedure??
I know the old mysql-front 2.5 which created on 2002 wont be able to create views, stored procedure etc, but I think it can read view tables and execute stored procedure right ??
please tell me your tought, this is the first time I am playing in reality using for in-house developing using delphi 5
once again, thank you in advance for your time to take reply :)
|All times are GMT +2. The time now is 15:06.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.