Re: Cannot connect to my Database
> I want my Database to be accessed from a webpage that others will be seeing.
Yes, so have the webpage connect to the DB as localhost, and set MySQL webapps privs using that host.
> it is very unclear what I have to do to allow my database to be accessed from anywhere
That's exactly what you do not want. If that were allowed, your DB would be hacked to pieces.
You want access to the DB to be tightly controlled. One mysql user is the DBA. A second mysql user is your webapp. You may need no others.
Users of your webapp are an entirely different issue. Do NOT register them as mysql users. Maintain a separate table of users, passwords and permissions which you administer such that the webapp obeys those rules in that table.
Subject
Written By
Posted
Re: Cannot connect to my Database
January 19, 2013 06:32PM
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.