Differences

This shows you the differences between two versions of the page.

--- configuration:ils:examples:koha_ilsdi_database [2023/03/20 17:09] – created demiankatz
+++ configuration:ils:examples:koha_ilsdi_database [2023/03/29 17:46] (current) – [Create a new MariaDB user in Koha server] demiankatz
@@ Line 1: / Line 1: @@
 ====== Configure Koha's database to allow access for VuFind® ======
-:!: Details coming soon.
+// 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:
+. Enter your password and access the MariaDB client (e.g. ''mysql -uroot -p'').
+. Create new MariaDB user
+To create a new MariaDB user, type the following command:
+<code bash>
+CREATE USER 'username'@'%' IDENTIFIED BY 'password';
+</code>
+. Give permission (privileges) to MariaDB.
+To do so, type the following statement:
+<code bash>
+GRANT SELECT ON databasename.* TO 'username'@'%';
+</code>
+. Save these settings:
+<code bash>
+FLUSH PRIVILEGES;
+exit
+</code>
 ---- struct data ----
 properties.Page Owner :
 ----