MySQL lite password

[Andrew Kluthe]

That's interesting, Pete. Good catch.

On Fri, Feb 20, 2015 at 5:02 PM, Peter Haworth <pete at lcsql.com> wrote:

> Hi Andrew,
> Turns out SQLite added a user authentication extension in 10/2014 that
> requires a password to access an SQLite database but it's not part of the
> SQLite library provided with Livecode.  It has to be compiled into the
> source and a compile time flag set to enable it
>
> See http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt
>
> I recently added a QCC request to update the SQLite library which is now
> about 8 months and several releases old, including the addition of this
> feature.
>
> On Fri Feb 20 2015 at 1:39:32 PM Andrew Kluthe <andrew at ctech.me> wrote:
>
> > Unfortunately, for a SQLite file there isn't really any built in
> > authentication/permissions features.
> >
> > With using only live code your only real option is to encrypt the entire
> > file either using built in encrypt/decrypt commands or shell out to
> > something that can.
> >
> > Kind regards,
> >
> > Andrew
> > On Feb 20, 2015 1:53 PM, "JB" <sundown at pacifier.com> wrote:
> >
> > > What is the proper way to add a password to
> > > a MySQL lite database?
> > >
> > > John Balgenorth
> > >
> > > _______________________________________________
> > > use-livecode mailing list
> > > use-livecode at lists.runrev.com
> > > Please visit this url to subscribe, unsubscribe and manage your
> > > subscription preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> > >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
Regards,

Andrew Kluthe
andrew at ctech.me