The Setup: Im building an app to model visually world data. A significant part of this project will be the database since that data is what is interesting. I should only need to allow SELECT queries, and perhaps eventually CREATE TEMPORARY TABLES should there be collaboration.
<?php DEFINE('SERVER_NAME', 'localhost'); //Database server name DEFINE('USER_NAME', 'myCPanelName_openSrc'); //Database user name DEFINE('PWD', 'opensrc'); //Database user password DEFINE('DB_NAME', 'myDatabase_appName'); //Database name ?>
The Problem: The data that would be exposed is my CPanel login name, and the database name. It seems leaving a door open to my database may have unseen consequences. Even while restricting access and using generic credentials.
The Question: What is standard practice in this situation? And how risky is this business of open-sourcing a database? Is data corruption/theft my only concern? Or are the consequences more sever?