3 Nov
2008
3 Nov
'08
9:22 a.m.
Hello Cliff,
ludo1960(a)lycos.co.uk wrote:
Thanks again for your help Bitfolkers, Proftpd binned
and WinSCP
installed, sound advice!
Congratulations.
I'm looking at installing an ODBC connector for
mySQL database, the idea
being that I want to connect from a Windows machine, OK OK I'm old
school! But I do have a very good reason for doing so!
I was looking at http://packages.debian.org/etch/php5-odbc as a
solution, any thoughts?
This is not the correct package, do not install it.
There is a distinct lack of documentation so that
makes configuration a
real chore, specifically if I create a database user, say dbuser and
grant him privaledges to the database then when I connect from my
windows machine my user becomes dbuser(a)cable25.uk.net or something
similar so the connection would be refused by the database.
I remember that in Cpanel there was an option for allow wildcard ODBC
access and this would eneble a connection for dbuser@anywhere. I'm
assuming this can be done from the command line but again I can't find
any documentation.
I'm not exactly sure that you want or need an ODBC connector - it is
only necessary if you are developing certain applications on your
Windows machine and you can connect to MySQL directly just fine without.
This is usually possible "out of the box" - simply create the user in
MySQL e.g. username="ludo" with hostname="*" and you should be able to
connect from your Windows machine.
Yours,
Robert Leverington.