PHP to MySQL db connections?
Posted: Mon Mar 17, 2003 7:58 pm
I understand the syntax and parameters of the basic "mysql_connect" command:
$db=mysql_connect("hostname","pw","un");
However, I've read and searched for hours now on mysql security and administration but can't find any specific information on how to connect to a remotely hosted db server using PHP on the web.
1) Do I have to create/grant a specific 'general' user account (un/pw) which can then be used in all my db connection scripts?
2) What is the best security strategy for web-based db connection and transactions?
Thanks in advance
$db=mysql_connect("hostname","pw","un");
However, I've read and searched for hours now on mysql security and administration but can't find any specific information on how to connect to a remotely hosted db server using PHP on the web.
1) Do I have to create/grant a specific 'general' user account (un/pw) which can then be used in all my db connection scripts?
2) What is the best security strategy for web-based db connection and transactions?
Thanks in advance