[Libreoffice-bugs] [Bug 125177] New: MySQL Connector is restricted to read-only access

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125177

            Bug ID: 125177
           Summary: MySQL Connector is restricted to read-only access
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: seb.lo at ldd.fr

Description:
One can only access remote MySQL databases read-only using "Connect directly"
from LibreOffice Base.
(no insert, update nor delete are possible, only selects)

Steps to Reproduce:
1. Have a write access to a remote MySQL or MariaDB database
2. Connect "directly" to it using LibreOffice Base
3. Open any table

Actual Results:
Data is read only

Expected Results:
Data should be writable


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Tested server version: 10.1.38-MariaDB-0+deb9u1 Debian 9.8

All works as expected using the "mysql" command-line client.

Version: 6.2.3.2
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU threads: 4; OS: Linux 4.9; UI render: default; VCL: gtk3; 
Locale: en-US (C); UI-Language: en-US
Calc: threaded

Other architectures and OS not tested yet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190508/7c79606e/attachment.html>