====== Configure Koha's database to allow access for VuFind® ======

// Thanks to Mohan Pradhan for developing this documentation. //

===== Create a new MariaDB user in Koha server =====

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:
<code bash>
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
</code>

3. Give permission (privileges) to MariaDB.

To do so, type the following statement:
<code bash>
GRANT SELECT ON databasename.* TO 'username'@'%';
</code>

4. Save these settings:
<code bash>
FLUSH PRIVILEGES;
exit
</code>