[BNM] odbc on xp & mysql

Karim Ahmed bnm at karimahmed.com
Fri Jul 6 10:50:11 BST 2007 

Try it and you may see the point of it - depends what you are after I guess.
There's an open source version if you don't need all the features.

On 7/6/07, andrew holway <andrew at moonet.co.uk> wrote:
>
> Whats the point in that? you have to pay for it!
>
> Its only by using and supporting the open source tools that makes them
> grow into bigger and better things,
>
> anyway, I like getting under the bonnet every now and then :-)
>
> Andrew
> moonet.co.uk
>
> On 06/07/07, Karim Ahmed <bnm at karimahmed.com> wrote:
> > Andrew. My advice is to use Sqlyog Enterprise (www.sqlyog.com ) instead
> of
> > phpMyAdmin. It is very fast, has a good GUI and a visual query builder
> very
> > similar to Access as well as DB migration and scheduled backup tools and
> all
> > sorts of other good stuff.
> >
> > On 7/6/07, andrew holway <andrew at moonet.co.uk> wrote:
> > >
> > > its actually
> > >
> > > GRANT ALL PRIVILEGES ON remote.* TO remote IDENTIFIED BY "remote";
> > >
> > > if you wanted to make it available to a single IP 89.99.99.99
> > >
> > > GRANT ALL PRIVILEGES ON remote.* TO remote at 89.99.99.99 IDENTIFIED BY
> > > "remote";
> > >
> > > If anyone wants to have a go connecting,
> > >
> > > host sql.moognu.co.uk
> > > user - remote
> > > password - remote
> > >
> > > :-) I haven't got windows handy
> > >
> > > Cheers,
> > >
> > > Andy
> > >
> > > On 06/07/07, andrew holway <andrew at moonet.co.uk> wrote:
> > > > GRANT ALL PRIVILEGES ON *.* TO USERNAME at IP IDENTIFIED BY "PASSWORD";
> > > >
> > > > I want to adapt this so I give one user access to one DB on any IP
> > > >
> > > > GRANT ALL PRIVILEGES ON test TO remote@* IDENTIFIED BY "PASSWORD";
> > > >
> > > > Its a shame phpmyadmin isnt set up for it.
> > > >
> > > > andy
> > > > moonet.co.uk
> > > >
> > > >
> > > >
> > > > On 06/07/07, Karim Ahmed <bnm at karimahmed.com> wrote:
> > > > > It's very straight-forward but you need to be careful to set up a
> > > MySQL user
> > > > > that ONLY has the permissions required for the task in hand (for
> > > security).
> > > > > e.g. specify the host name of the client as the only allowed host
> and
> > > > > read-only access if that's all you need.
> > > > >
> > > > > Get the ODBC driver from mysql web site and it's very
> straightforward
> > > to set
> > > > > up.
> > > > >
> > > > > K
> > > > > On 7/6/07, andrew holway <andrew at moonet.co.uk> wrote:
> > > > > >
> > > > > > Well, The first step is installing the mysql odbc driver
> > > > > > http://dev.mysql.com/downloads/connector/odbc/3.51.html
> > > > > >
> > > > > > :-)
> > > > > >
> > > > > > On 06/07/07, Tom Coady <tom.coady at gmail.com> wrote:
> > > > > > > On 7/5/07, andrew holway <andrew at moonet.co.uk> wrote:
> > > > > > > >
> > > > > > > > Has anyone set up odbc to remote mysql before? Can you
> describe
> > > the
> > > > > > > > steps?. We have the mysql odbc driver installed on the
> client XP
> > > > > > > > machine, mysql is running on linux.
> > > > > > >
> > > > > > >
> > > > > > > No, but I'd like to. I've inherited such a base that I'd love
> to
> > > backup
> > > > > > &
> > > > > > > access this way so if you succeed I'd be very interested to
> know
> > > how it
> > > > > > > goes.
> > > > > > > --
> > > > > > >
> > > > > > > BNM Subscribe/Unsubscribe:
> > > > > > > http://www.brightonnewmedia.org/options/bnmlist
> > > > > > >
> > > > > > > BNM info/archives:
> > > > > > > http://www.brightonnewmedia.org/
> > > > > > >
> > > > > > > BNM powered by Wessex Networks:
> > > > > > > http://www.wessexnetworks.com
> > > > > > >
> > > > > > --
> > > > > >
> > > > > > BNM Subscribe/Unsubscribe:
> > > > > > http://www.brightonnewmedia.org/options/bnmlist
> > > > > >
> > > > > > BNM info/archives:
> > > > > > http://www.brightonnewmedia.org/
> > > > > >
> > > > > > BNM powered by Wessex Networks:
> > > > > > http://www.wessexnetworks.com
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Karim Ahmed
> > > > > Sweet Code Ltd
> > > > > http://www.sweetcode.co.uk
> > > > > Phone: +44 1273 383584
> > > > > Skype: karim.ahmed
> > > > > SIP:     3808296
> > > > >
> > > > > Member of the Federation of Small Businesses
> > > > >
> > > > > IS YOUR EMAIL PRIVATE? Ensure you have at least basic security:
> > > > > o For web mail such as GMail and Hotmail, the address bar must say
> > > https://
> > > > > instead of http://
> > > > > o For desktop clients like Outlook, check that POP and SMTP
> servers
> > > require
> > > > > an encrypted connection in the email account settings.
> > > > > If you can't do the above, consider switching your mail provider.
> > > > > --
> > > > >
> > > > > BNM Subscribe/Unsubscribe:
> > > > > http://www.brightonnewmedia.org/options/bnmlist
> > > > >
> > > > > BNM info/archives:
> > > > > http://www.brightonnewmedia.org/
> > > > >
> > > > > BNM powered by Wessex Networks:
> > > > > http://www.wessexnetworks.com
> > > > >
> > > >
> > > --
> > >
> > > BNM Subscribe/Unsubscribe:
> > > http://www.brightonnewmedia.org/options/bnmlist
> > >
> > > BNM info/archives:
> > > http://www.brightonnewmedia.org/
> > >
> > > BNM powered by Wessex Networks:
> > > http://www.wessexnetworks.com
> > >
> >
> >
> >
> > --
> > Karim Ahmed
> > Sweet Code Ltd
> > http://www.sweetcode.co.uk
> > Phone: +44 1273 383584
> > Skype: karim.ahmed
> > SIP:     3808296
> >
> > Member of the Federation of Small Businesses
> >
> > IS YOUR EMAIL PRIVATE? Ensure you have at least basic security:
> > o For web mail such as GMail and Hotmail, the address bar must say
> https://
> > instead of http://
> > o For desktop clients like Outlook, check that POP and SMTP servers
> require
> > an encrypted connection in the email account settings.
> > If you can't do the above, consider switching your mail provider.
> > --
> >
> > BNM Subscribe/Unsubscribe:
> > http://www.brightonnewmedia.org/options/bnmlist
> >
> > BNM info/archives:
> > http://www.brightonnewmedia.org/
> >
> > BNM powered by Wessex Networks:
> > http://www.wessexnetworks.com
> >
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM info/archives:
> http://www.brightonnewmedia.org/
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>



-- 
Karim Ahmed
Sweet Code Ltd
http://www.sweetcode.co.uk
Phone: +44 1273 383584
Skype: karim.ahmed
SIP:     3808296

Member of the Federation of Small Businesses

IS YOUR EMAIL PRIVATE? Ensure you have at least basic security:
o For web mail such as GMail and Hotmail, the address bar must say https://
instead of http://
o For desktop clients like Outlook, check that POP and SMTP servers require
an encrypted connection in the email account settings.
If you can't do the above, consider switching your mail provider.

More information about the BNMlist mailing list. Powered by Wessex Networks