Hi Dan, Thanks for the hints. So far I am the only user, but shortly this will not be the case anymore. Non-Administrator users will only need access to ONE DB anyway. So I won't grant them access to any of the others. Also, I will restrict access to the tables and views within that DB to the users that need to work with them. Regards Heinz
On Wed, 13 Mar 2013 20:37:36 +0100, Dan Lewis <[email protected]> wrote:
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 <[email protected]> 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
-- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: [email protected] 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
