Page 1 of 1

RESOLVED - Remote MySQL/MariaDB database

Posted: 29 Mar 2018, 09:05
by OK1FWG
I am trying to setup Log4OM with a Mysql database on a remote machine. The reason for it is one common storage place with backup etc.
I have a full access to the database, but even if the database is created, I am still fighting with some other access violations, privileges on this and that etc. My DB was named 'log4om', the user created in mysql.user is 'log4omUser'@'localhost' - BUT I am not a localhost, I am comming from other world.
May I know the sql structure and what grants I need for the user to access the database? Is there anybody who is using similar scenario?
Thanks & 73!
Willi, OK1FWG

Re: [SOLVED] Remote MySQL/MariaDB database

Posted: 29 Mar 2018, 12:21
by OK1FWG
It is working now. Adjusting some grants.

Re: RESOLVED - Remote MySQL/MariaDB database

Posted: 27 Apr 2018, 17:37
by pd5dj
Hi Can you share the exact GRANTS u you have used to get it to work?

I am in the same spot.. using my webhosting/mysql server for logbooks.
And weblogbooks: http://pd5dj.nl/index.php/logbooks/

I am having trouble to get connected to the database, and get SELECT table errors