How to access my database in PHPMyAdmin from a different computer?

Question

I am working on my Java application in Eclipse that connects to the database and makes some queries with the data. This database has been created and managed in PHPMyAdmin. The database is stored locally and now I would like to make it accessible not only from my computer, but for anyone who will run my application on his computer. Can anyone tell me what is the procedure? How can I make the database "online"? Should I store the database on some remote server? If so, what is the procedure?

I know this question is not so much straight-forward, but I hope you will give me some idea how to deal with it.

Thanks in advance!

Answer 1

In this situation you should store the database on an external server who are better at managing databases with more security/backups etc.

If you're looking for scalability as well you could get an Amazon AWS Micro Instance in the cloud for free for a year which includes a large amount (20GB) of RDS (their relational database service based on MySQL) for free.

There is a great Stack Overflow question on Using PHPMyAdmin to administer Amazon RDS as well to get you started with something you are familiar with.

You can use MySQLDump to copy your current database from your local machine to RDS if you needed.

(A, completely non-extensive, list of) Mysql Hosting Providers

• Webfaction - Good web user interface. Does more than just database hosting. Lots of documentation.
• Amazons RDS - Cloud based. Reliable. Offers free tier
• Rackspace - Cloud based. Excellent customer service.

Or, host your own on something like these

• Linode - Has lots of documentation of getting Mysql installed
• Digital Ocean - SSDs for great speed. Again great documentation on getting Mysql installed