php site help please

[spooonynick]

Heya pepps! I have got a site which has took a while to make and the only problem is a php problem in my site.php at line 11  here is what i get when trying to access my site.  " Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'192.168.1.1' (using password: YES) in /www/zzl.org/s/p/o/spoonynicks/htdocs/admin/lib/site.php on line 11  Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /www/zzl.org/s/p/o/spoonynicks/htdocs/admin/lib/site.php on line 11 CDatabase::Connect() error "  here is the site.php code download it here to check as there is to much to put here. http://hotfile.com/dl/98759071/e522863/site.php.html

[David_Powers]

spooonynick wrote:

Heya pepps! I have got a site which has took a while to make and the only problem is a php problem in my site.php at line 11  here is what i get when trying to access my site.  " Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'192.168.1.1' (using password: YES) in /www/zzl.org/s/p/o/spoonynicks/htdocs/admin/lib/site.php on line 11 

The error message is very clear. It says that access to the database for the root user was denied, and that a password was used. In other words, either the password you supplied was wrong or you are trying to access the database remotely. Most hosting companies do not permit remote access to MySQL.

By the way, using the root user account for a website is extremely unwise. The root superuser account has unlimited privileges over every database. If there are any security gaps in your code, you're extending an open invitation to hackers to trash your site.