I have setup and configured a test database in Specify 6. I can access the database on the machine on which the database was created and hosted (local host). But I cannot access it from a different machine on the same network (remote client).
I am using the exact same credentials on the remote client as I am on the local host. I am using the IP of the local host. I have generated a Master Key on the remote client using the same credentials I used to create a Master Key on the local host.
Could this be caused by Mariadb not being accessible from outside the local host?
This seems to be a network issue and not a MariaDB issue. Did you deploy your DB on an internal server or just another PC on your network? Some networks configurations might not allow you to access other PC on your network. Are you sure you are using the correct IP address? Do you have a local network expert that can help you out?
Thanks for responding. I have this installed in a server on my network. I have a volunteer who is a network administrator in his day job who has been looking into this issue with me. I have been able to remote in to the server desktop environment using RDP. So I am fairly certain the IP and network configurations âshouldâ be correct, but Iâve been wrong before. I will let the person I am working with know of your suggestion.
Hi @qfloch,
Perhaps i can possibly give some guidance here if the documentation @markp provided does not solve the issue.
On the localhost where you can access the Specify database, do check that your specifymaster account has access to the database From host: %, for example:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, LOCK TABLES ON Ichthyology.* TO âspecifymasterâ@â%â IDENTIFIED BY âabcdefgh12345678â;
FLUSH PRIVILEGES;
After this, you shouldnât have any issues accessing the database remotely from any networked computer at your institution, provided there is no firewall blocking port 3306.