Hello,

I am very new to this system. I just created a new database on a computer that will serve as the home desktop, but also be accessed remotely. I am now trying to add a new computer to the system for remote access - the desktop is a PC and the computer to be added is a Mac. I have downloaded Java and MySQL on that computer and changed the default to InnoDB on both computers. When I type in the command > GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON Database Name.* TO 'Master Username'@'ip address of client computer' IDENTIFIED BY 'Master Password'; suggested on http://specifysoftware.org/content/specify-system-setup, I get the error message “Illegal GRANT/REMOVE command…” (I also just wanted to state that in order to get the above to work to even that point and not give me the initial error message “No database selected” I had to type "> use specify" before even putting in the longer command above).

I am not sure if I did something wrong when creating the initial database.

Any suggestions?

As well, once I get that part working – it is not entirely clear to me how on the remote computer I actually access the database on the desktop.

Thank you! (and apologies if this is redundant to someone else’s post – I looked through a number of the former ones and did not come across one which answered my question)