How to connect libreoffice with ODBC

Create database 

  • Open MySql command line client
  • Enter pasword
  • Create database: create database 'databasename'_mysqldb;
  • Enter

Connect to the libreoffice base

  • Open libreoffice base
  • Connect to existing database
  • Select MySQL from drop down menu option
  • Select next
  • From the option - select the Connect using ODBC 
  • Select next
  • Browse the database
  • Click organized
  • Click Add
  • Select MySQL ODBC Unicode Driver
  • Fill-up the Connector/ODBC
    • Data source name: put the database as create above: 'databasename'_mysqldb;
    • For the discription: can put as above: 'databasename'_mysqldb;
    • Top/Ip server: localhost
    • Port: 3306
    • User: root
    • Password: 'your password'
    • Choose the database: Select your database: 'databasename'_mysqldb;
    • Test the connection
    • If successful - click ok
    • Click ok again
    • Data source: choose you database: 'databasename'_mysqldb;
    • Click ok
    • Click next
    • For user name: root
    • Check the 'required password' & put your password
    • Click test connecting
    • In pop-up windows: put your password
    • Click ok
    • See the status - it's successful ?
    • If yes, click next
    • Choose weather you want to register the database or not (optional)
    • Click next
    • And click Finish
    • Give the name and save the file
    • After that you can open the file and creata the table, query, form, report.. 

For more detail - you can see this youtube from TheFrugalComputerGuy