Configure Koha's database to allow access for VuFind®

Thanks to Mohan Pradhan for developing this documentation.

MariaDB is a community fork of MySQL. The most recent versions of Koha support both MySQL and MariaDB; this example uses MariaDB, though MySQL should work very similarly.

To use the KohaILSDI driver, you will need to allow your VuFind® server to connect to your Koha database.

In the example commands below, three key values are used that you will need to substitute with your own values:

• username = the username for your new database account
• password = the password for your new database account
• databasename = the name of your Koha database

Here are the steps for setting up that new MariaDB user:

1. Enter your password and access the MariaDB client (e.g. mysql -uroot -p).

2. Create new MariaDB user

To create a new MariaDB user, type the following command:

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

3. Give permission (privileges) to MariaDB.

To do so, type the following statement:

GRANT SELECT ON databasename.* TO 'username'@'%';

4. Save these settings:

FLUSH PRIVILEGES;
exit