uniherb

Thank you, that's pretty much what I suspected.  I did use cPanel to grant the permissions, but they're not adequate for the application.  Cheers.

Hi, I'm attempting to set up a database for use by a herbarium for the cataloguing of collection objects.  I want to use software called 'Specify'.  I have had some success setting up locally hosted databases but want to make one more widely accessible, hence my subscription to this service.  I am following the guide here: https://www.sustain.specifysoftware.org/wp-content/uploads/2017/03/Setting-Up-Specify-to-Use-a-Networked-MySQL-Server.pdf.  I have tried to create what they describe as an 'IT User' with all the permissions they mention.

They use the code:

MYSQL> GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES, ALTER, CREATE, DROP, INDEX, GRANT OPTION ON DatabaseName.* TO 'ITUserName'@'ClientIpAddressRange' IDENTIFIED BY "ITUserPassword";

MYSQL> GRANT RELOAD ON *.* TO 'ITUserName'@'ClientIpAddressRange' IDENTIFIED BY "ITUserPassword";

which I have tried my best to implement via the GUI.  Entering it via phpMyAdmin (replacing the user/password/DBname fields where approriate) gives an error saying I do not have permission to grant such permissions.  Login attempts to create the database structure via 'Specify' fail, saying I lack permissions in the database.  Is it possible for my created users to gain such permissions, or is it restricted by this host?  I believe I simply need them for set-up and occasional DB maintenance in the case of major updates, but they are essential for this project to work.