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:
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