Linux.com

Home Linux Community Forums New to Linux Getting Started with Linux database (yes, I did try a search first)

database (yes, I did try a search first)

Link to this post 06 Feb 13

I am presently building a pc to use as a small business database server with the ability to be accessed from Iphones, Ipads and PCs connected remotely through the internet for the limited purpose of adding and accessing information.

I am presently using XP svc pk3, and Access 2003 for building and maintaining the database, but have not yet set it up for remote access.

I have diddled with Caldera and the command line, 12 years ago as part of a general PC course. And have set up and used MINT just for internet access.

Basically I am looking for suggestions for distributions, Database software and how to allow queries and input remotely. Additionally I need to scan and track photos and send query reports via email (quotes, invoices etc.)


I know I can do this with Wind-Blows, Access and RealVNC, but am a bit paranoid about the users ability to screw with my setup.

Link to this post 07 Feb 13

Any Linux based distribution can run mysql or mariadb (opensource databases similar to MSsql). The real question is whether you want the source system to be a server for limited use or a general desktop.

As for remote access you can read a little at http://www.rackspace.com/knowledge_center/article/mysql-connect-to-your-database-remotely , in which you want choose to access it remotely via mysql clients, a ssh connection, a website or even if you want to program an application to access it remotely. Depending on your use your best bet based upon the devices listed would be to use php and apache webserver to build a website as a from end similar to ms access forms what can accessed from any web-browser.

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board