Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

     So, you also noticed this. When using the native connector, MySQL 
will display all of the databases for which the given user has been 
given access. JDBC/ODBC will only display the specific database that is 
listed in the database file.
      Some thoughts. If you are going to use the native connector for 
MySQL, group the type of databases contained in it according to use. 
Then allow one or a few users access to each group.
     With JDBC/ODBC, you have to have a Base file for each database. 
Or, you can right click in the list section of the database window to 
select Database > Properties. There you can change the database you want 
to view.
      To view only one database at a time using the native connector, 
you would have to set the permissions so that only one user can access a 
given database other than the administrator. Then you can have base 
connected to MySQL and change the user name doing what I mentioned in 
the previous paragraph.
      Maybe you have a different method of switching databases when you 
need to do so.

--Dan


On 03/13/2013 12:46 PM, Heinrich Stoellinger wrote:
> Hi Dan,
> Thanks again! Eureka! I had to add the ".oxt" file extension to the name.
> Now I can access a MySQL database stored on the Debian Wheezy system 
> (MySQL 5.5)
> from my laptop client running Linux-Mint-Nadia. The systems are connected
> through a LAN. They are both 32-bit.
> I will test it more in the coming days and report on the results to you.
> I wonder about ONE thing: Even though I specify the name of the 
> database for
> the connector, LO-Base displays ALL the additional databases that are 
> defined
> on the server. This is unlike JDBC/ODBC where only the ONE DB 
> mentioned in the
> definition of the LO-odb-file is shown in the list. Of course one can 
> always
> specify MySQL-GRANT-statements as required. But somehow I would prefer 
> to only
> see the intended DB.
>
> Kind regards,
> Heinz
>
>
> On Wed, 13 Mar 2013 16:56:41 +0100, Dan Lewis 
> <elderdanlewis@gmail.com> wrote:
> >       When I went to the Extension web page, I had to select "Base
> > Extensions" and "Any Version". That is when I saw two extensions listed:
> > "Access2Base" and "MySQL Native Connector". When I clicked on the
> > latter, I went to the MySQL Native Connector page. Next you need to
> > click the "1.0" link below Version to get to the download page.
> >       A direct link to the downloads:
> > http://extensions.libreoffice.org/extension-center/mysql-native-connector/releases/1.0. 
> >
> >
> > --Dan
> >
> > On 03/13/2013 11:27 AM, Heinrich Stoellinger wrote:
> > > Hello Dan,
> > > Sorry to be a nuissance - but I can only find Access2Base under Base
> > > Extensions.
> > > The page is
> > > http://extensions.libreoffice.org/extension-center?getCategories=Base_Extension&getCompatibility=any 
> > >
> > >
> > > Is this correct?
> > > Regards
> > > Heinz

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted