Connecting safely with a MySQL database?
Posted: Wed Aug 25, 2010 3:03 pm
Hi,
I am putting together a website which uses MySQL to store data and populate some fields. I have the database working correctly, but my question is regarding the correct way to connect with MySQL. I am currently connecting using root as the user and the root passward, which as populated via a separate file, incorporated via the require function.
My main question is:
- Is this a security flaw for the website?
+ Is it worth me spending the time having each registered user of the website having set priviledges on the database?
I'd really appreciate any thoughts on this as this is my first go at doing this.
Thanks
I am putting together a website which uses MySQL to store data and populate some fields. I have the database working correctly, but my question is regarding the correct way to connect with MySQL. I am currently connecting using root as the user and the root passward, which as populated via a separate file, incorporated via the require function.
My main question is:
- Is this a security flaw for the website?
+ Is it worth me spending the time having each registered user of the website having set priviledges on the database?
I'd really appreciate any thoughts on this as this is my first go at doing this.
Thanks