3 Nov
3 Nov
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.
10:03 a.m.
On Mon, Nov 03, 2008 at 07:58:14AM +0100, ludo1960(a)lycos.co.uk wrote:
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.
MySQL uses % as a wildcard for privileges, so a row in one of the
_PRIVEGES tables with 'foo'@'%' in the GRANTEE column gives whatever
privilege the row refers to to the user foo at any host. You can add
privileges from the command line tools using the GRANT command [1], or
using normal SQL commands (though you do have to run 'mysqladmin
flush-privileges' (plus whatever connection and user options you need)
to get those changes to take effect).
Can anybody suggest where I can find out more about
this?
MySQL has fairly comprehensive documentation, not sure about the ODBC
stuff though.
Robert
[1] http://dev.mysql.com/doc/refman/5.0/en/grant.html
Or whatever version of the docs refers to the version of MySQL you
have installed.
________________________________________________________________________
Robert McWilliam rmcw(a)allmail.net www.ormiret.com
Life is complex: it has real and imaginary parts.
11:33 a.m.
ludo1960(a)lycos.co.uk wrote:
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!
With the greatest respect then do you think you could elaborate on this
somewhat?
It's just that I can't think of very many good reasons to have a mySQL
database accept connections from any host that is live on the interweb.
It's just asking for trouble.
If you'd rather talk off-list then please feel free to contact me
directly, but I'd recommend you talk to someone about this a bit further
before you do it.
Regards,
n
5662
days inactive
5662
days old
3 comments
4 participants
participants (4)
-
ludo1960＠lycos.co.uk -
Nigel Rantor -
Robert Leverington -
Robert McWilliam