uniherb
-
Posts
2 -
Joined
-
Last visited
Posts posted by uniherb
-
-
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.
[Solved] Remote MySQL permissions
in Customer Service
Posted
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.