[BNM] odbc on xp & mysql

[Karim Ahmed]

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.