PHP & MySQL & root

PHP & MySQL & root

Post by Mike » Fri, 11 Apr 2003 01:41:40



I'm new to Apache/PHP/MySQL/Linux and I'm still in the learning process
(coming from Windows/IIS/ASP background).

A tutorial site covering MySQL and PHP has the following code...

    $db = mysql_connect("localhost", "root");

    mysql_select_db("table",$db);

    $result = mysql_query("SELECT ...",$db);

I can revise the code and it works fine on my site, exactly what I would
want.

However, I noticed that the root account is being used and I can't help but
wonder if there are any security implications.

I'll be creating/updating/deleting/retrieving records in pre-set tables
using PHP and MySQL.

What are the dangers of using the root account within a PHP script as shown
above?

--
Mike

 
 
 

1. Apache compile & Php & mysql

Hello.
How i can to compile apache for it works with php and how to compile php for
it works with apache and mysql ?

Regards.
--
---------------------------------------------------------------------
Aix,Linux,Humor,Zoco
http://web.madritel.es/personales2/jperezm
--------------------------------------------------------------------

2. Dual monitors & x86 & Solaris 2.4

3. Apach&mysql&php install

4. Kernel panic - error reading block from /dev/hda4

5. Apache & mysql & php not working

6. need info on one time passwords

7. &&&&----Looking for a unix shell------&&&&&

8. various questions (easy, I hope)

9. ppp && PPPoE && ADSL && net && buffer(s)

10. 没有人用中文吗?

11. &&&&&& SUGGESTION ??? &&&&&&&&

12. Hercules &&&&&& SVGA ?

13. PERL && mod_perl && FreeBSD && Apache