"Access denied for user @ localhost to database mysql"

I done a google search- and it i came across the following solution:

"In this case- you must restart the server with the --skip-grant-tables option and edit your /etc/hosts file or \windows\hosts file to add an entry for your host."

This happens despite me using the root account and entering the correct password.

I have no idea how to do this...I am very bad at coding- a real rookie so Id appreciate a very dumbed down explanation ;)

Thanks guys! Really eager to supplement my PHP with SQL- so any help much appreciated.

I created a data base with DOS- with MySQL. How can i convert it in an SQL or MySQL file? Thanks
I ve got the database in DOS. I want to convert it in a file. How can i do it?

for displaying (for e.g.) the most viewed posts on a website- i am confused:

1) what script is it?
2) is it easy to do?
3) is there a tutorial to teach you how?
4) if it is PHP can you do it in asp.net or coldfusion?
5) if you do not know what i mean on like every video site you can view by most viewed and recently added etc like on youtube for sorting out videos- thats the script i need?
6) has MySql go tanything to do with it?
7) (if yes) do you have to use MySQl or can you use SQL server or something like that?

Thank you for your time and patience i know it is a lot to right and everything is much appreciated.

ok this is what i m trying to do.

firstly this is the address of my php file

So in php i want to find out how many pages i have each have 13 records and the total records i have is 88

BUT!!! HERE IS THE THING I CANT FIGURE OUT!!!
I got php to count out how many pages i will have
$numpage = round($count/13);
It output 7
but when i manually go to the address
http://www.runescapegod.com/weapon.php?pagenum=1
i can do this until
http://www.runescapegod.com/weapon.php?pagenum=13

Which is 13 pages HUH!? i really dunno why please help me
on this logic or syntax thing

i m using this to count my rows
$result2 = mysql_query("SELECT * FROM weapon");
$count=mysql_num_rows($result2);

and yes cpanel says its 88 records too

I m so confuse and angry please help me
AHH STUPID ME!!!!!! I forgot to edit the old thingy gah 30mins wasted

This is my current codes

mysql_connect("$host"- "$username"- "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
////////////////////////////////////////////////////
$result = mysql_query("SELECT * FROM weapon ORDER BY name");

while($row = mysql_fetch_array($result)){

echo "<tr>";
//start row
echo "<td>";

echo "<a href=\"weapon2.php?id=";

echo $row["id"];
echo "\">";
echo $row["name"];
echo "</a>";

echo "</td>\n";
echo "<td>";
echo $row["member"];
echo "</td>\n";
echo "<td>";
echo $row["requirement"];
echo "</td>\n";
echo "<td>";
echo $row["type"];
echo "</td>\n";
//end row
echo "</tr>";
}

However there are too many results and i want to display them in pages like each page i get only 8 results.

Please help and assist
Thanks guys the Limit thing works
i dunno who to choose best answer... well lets just take the first 1 ( i love panda )
O its not a panda.. its a piglike rat or something

My setup is;
Apache -Mysql and activeperl.

I want to move (not copy) images from one folder to another.

The current script i tried using COPIED the image; and the image in the new folder had 0 bytes!