Frequently asked questions - Base

    From The Document Foundation Wiki
    < Faq‎ | Base

    How can I connect to a MySQL server under Linux?

    For an ODBC connection to work under Linux (using unixODBC) a file to list the installed database drivers is required (in general the section name is that of the database, but it is not required).

    Put the file odbcinst.ini in the directory /etc :

    Description  = MySQL driver 
    Driver       = /usr/local/lib/ 
    Setup        = /usr/lib/ 
    FileUsage    = 1

    and a file listing the database connection(s).

    The first section defines the driver to use for a data source (database).

    There are as many sections as there are data sources. This seems to create unnecessary duplication of driver definitions, but it is not clear why).

    Put the file .odbc.ini in the user's home directory :

    [ODBC Data Sources] 
    TestMySQL  = MySQL   
    Description = Test TJ 
    Driver = MySQL 
    DSN = TestMySQL 
    Trace = Off 
    TraceFile = <trace filename>
    SERVER = @IP or name
    PORT = 3306 
    DATABASE = test 
    USER = user MySQL
    Password = corresponding password

    In this case the command will be : isql -v TestMySQL .

    Start LibreOffice, select "View > Data sources" from the menu or press F4. The database dialogue will open below the icon bar.

    Right click at the left and choose "Manage data sources".

    In the window that opens click on "New database", enter it's name, choose ODBC from the list of database types, then click on the ellipsis (...) at the left.

    In the window that opens choose your database (the database names that appear are those that have been defined in the .odbc.ini file in your home directory). Choose the one you require.

    Click on the next tab (ODBC), enter the identifier, click the "password required" checkbox if necessary, then "OK".