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
- Log in to post comments