This is an old revision of the document!

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. Here are the steps for setting up a new MariaDB user:

1. Enter your password and access the MariaDB client.

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

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

3. Give permission (privileges) to MariaDB. To do so, type the following statement:

GRANT ALL PRIVILEGES ON databasename  .* TO 'username'@'%' WITH GRANT OPTION;

4. Save these settings:

FLUSH PRIVILEGES;
exit.