RESOLVED - Remote MySQL/MariaDB database

Locked
OK1FWG
Novice Class
Posts: 3
Joined: 29 Mar 2018, 08:43

RESOLVED - Remote MySQL/MariaDB database

Post 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
OK1FWG
Novice Class
Posts: 3
Joined: 29 Mar 2018, 08:43

Re: [SOLVED] Remote MySQL/MariaDB database

Post by OK1FWG »

It is working now. Adjusting some grants.
pd5dj
New user
Posts: 1
Joined: 27 Apr 2018, 17:24

Re: RESOLVED - Remote MySQL/MariaDB database

Post 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
Locked