Page 1 of 1

[Solved] mysql warning

Posted: Wed Sep 06, 2006 7:50 am
by shaneshup
Hiya Guys

I am having problems with a script that i have installed. My understanding of php and mysql is pretty much none existent (i simply followed the read me file to install)
Whilst the layout and and images are all ok, some of the pages show me:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'interes2'@'localhost' (using password: NO) in /home/interes2/public_html/its-myspace/index2.php on line 69

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/interes2/public_html/its-myspace/index2.php on line 69

Warning: mysql_query() [function.mysql-query]: Access denied for user 'interes2'@'localhost' (using password: NO) in /home/interes2/public_html/its-myspace/index2.php on line 70

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/interes2/public_html/its-myspace/index2.php on line 70

Warning: mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /home/interes2/public_html/its-myspace/index2.php on line 71

Warning: mysql_query() [function.mysql-query]: Access denied for user 'interes2'@'localhost' (using password: NO) in /home/interes2/public_html/its-myspace/index2.php on line 88

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/interes2/public_html/its-myspace/index2.php on line 88

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/interes2/public_html/its-myspace/index2.php on line 91

Now this means absolutly nothing to me, i have looked at stedted lines in the index2.php file, but like i said my understanding is none existent.

I was just wondering if any of you folks could help me out. Does anyone have a simple solution?

The site is http://www.it-myspace.com, and the effected pages are backgounds, layouts and most of the graphic pages (just incase this makes it easier to understand!!)

Warmest Regards

Shane

Posted: Wed Sep 06, 2006 8:05 am
by CoderGoblin
Warning: mysql_query() [function.mysql-query]: Access denied for user 'interes2'@'localhost' (using password: NO) in /home/interes2/public_html/its-myspace/index2.php on line 69

This is your main error, the others will probably go away when you fix this. Not an MySQL guru but mysql_connect has a password field you should use when connecting.

Posted: Wed Sep 06, 2006 8:10 am
by volka

Posted: Wed Sep 06, 2006 9:05 am
by GM
Further to the other responses, and given that you profess to have no knowledge whatsover of this, your first error is simply an invalid username/password message from MySQL. It is basically saying that the username/password you are trying to connect to the database with is not valid.

You need to check your database account, check the permissions on your database, and check that the database really is on localhost.

Posted: Wed Sep 06, 2006 10:27 am
by shaneshup
WOW!! You guys are great, Many thanks to all for the advise of where to look etc...

Everything appears to be working fine.

Sorry if i came across daft, but i am sure you can all appreciate the frustrations of a newbie!!!

Thanks Again

Warmest Regards

Shane :D