Re: MySQL online database for 5 users
Posted by: Rick James
Date: October 17, 2014 07:55AM

Executive summary: You will have to learn a bunch of stuff.

Details:

MySQL can certainly do it for "free". But there is a learning curve. Some of the technical details...

To allow the users to get in, open up the firewall for port 3306.
For each user:
GRANT ALL PRIVILEGES ON dbname.* TO "user1"@"11.22.33.44" IDENTIFIED BY "password-1";
CREATE DATABASE dbname;
CREATE TABLE ...

As for buying another disk, that may be unnecessary -- unless they will be dealing with lots of data, a couple of GB or so might be sufficient for the mysql program plus the equivalent of a few million "rows" of data.

It's unclear whether you also need Apache and PHP (suggest WAMP or other combo-product that provides all the stack), or whether your "forms" will continue to be in Excel.

As for connection between Excel and MySQL, I am not versed in that. Search for Excel in
mysql.rjweb.org/bestof.html

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL online database for 5 users
October 17, 2014 07:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.