Differences

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

--- configuration:ils:examples:koha_ilsdi_database [2023/03/24 16:07] – sturkel
+++ configuration:ils:examples:koha_ilsdi_database [2023/03/29 17:46] (current) – [Create a new MariaDB user in Koha server] demiankatz
@@ Line 3: / Line 3: @@
 // Thanks to Mohan Pradhan for developing this documentation. //
-=====Create a new MariaDB user in Koha server=====
+===== 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:
+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.
-. Enter your password and access the MariaDB client.
+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 'user1'@ '%' IDENTIFIED BY 'password';
+CREATE USER 'username'@'%' IDENTIFIED BY 'password';
 </code>
 . Give permission (privileges) to MariaDB.
 To do so, type the following statement:
 <code bash>
-GRANT ALL PRIVILEGES ON databasename  .* TO 'username'@'%' WITH GRANT OPTION;
+GRANT SELECT ON databasename.* TO 'username'@'%';
 </code>
@@ Line 24: / Line 36: @@
 <code bash>
 FLUSH PRIVILEGES;
-exit.
+exit
 </code>
 ---- struct data ----