The Ultimate Guide to High Availability with MariaDB

Comments - LibreOffice Base

1 year, 11 months ago Richard Herbert
Re: LibreOffice Base

I appreciate your quick response time.

It turns out my problem [solved] was more basic:

1. I had defined the user "rherbert" in a command line but had not granted privileges to the user. I resolved this by logging into mariadb and adding:

GRANT ALL PRIVILEGES ON *.* to 'rherbert'@'localhost' WITH GRANT OPTION;

2. I also needed to change the SERVER in DSN to "localhost" and adjust the DSN to be more generic as follows:

[CAIDdb-server] Description=CAIDdb server Driver=MariaDB ODBC 3.1 Driver SERVER=localhost USER= PASSWORD= DATABASE=CAID PORT=3306

These changes worked well. I will also be able to have multiple users log in using the more generic DSN.

I am pleased with the connectivity between Libreoffice Base and mariadb - well done mariadb developers!

Thanks, Richard from caid.ca

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.