How to connect my php script to database?

[flash.engine50]

Hi, I am here new and I don't know what I have to do. I have read somethings in forum, but I didn't find.
I have created database, mysql user, added user to database and I gave all permission to user.

my php script:

$host="localhost"; // Host name
$username="hawksvk_fe"; // Mysql username
$password="mypassword"; // Mysql password
$db_name="hawksvk_database"; // Database name

//Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

Result: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'hawksvk_fe'@'web7.vital.x10hosting.com' (using password: YES) in /home/hawksvk/public_html/aaa.php on line 11

Please help me, thank you.

[niagaradad]

you are passing in a password, are you sure it is the correct password? If the password wasn't being accepted it would say (using password: No).

[MaestroFX1]

Post the full script or at least post what's around line 11.

Because the lines that you have posted alone can't do that.

There would be only two outcomes in this case(error)
#1 cannot connect to server
#2 cannot select DB

[flash.engine50]

mysql_connect("$host", "$username", "$password")or die("cannot connect to server"); //this is line 11, password is good

[MaestroFX1]

What is the url for the faulty page ?

[flash.engine50]

http://flash-engine.pcriot.com/aaa.php

Can I use Mysql database, if I have only freehosting here?

[MaestroFX1]

Can I use Mysql database, if I have only freehosting here?

You are allowed to use upto 2 Databases.
MySQL and PostGRE both are supported.

Check out your cPanel page.

[flash.engine50]

Is something more, what I have to set?

[MaestroFX1]

Just now I (re)generated the error on my and clearly arrived at conclusion that it is an “authentication error”.

Follow this step-by-step:

1. Go to your cPanel page and click “MySQL Database Wizard”, you will be asked to create a database (mysql).
Type a name for your database,for example – mydb001.

$db_name = yourusername_whatyoutypedjustnow.

For you, $dbname = hawksvk_mydb001 //to be used in php

Click Next.

2. Enter username and password “for the database” (hawksvk_mydb001).
Characters for username <= 7.
$username = hawksvk_usr001 //to be used in php

3. Temporarily grant all privileges and proceed.

4. You will get conformation that
User hawksvk_usr001 was added to the database hawksvk_mydb001.

Check this page “MySQL Databases” before you go any further to ascertain that the created database and user are linked with each other.
If not, use “Add User To Database“and link them.

Now, php section:

------start of code

<?
$host="localhost"; // Host name
$username=" hawksvk_usr001"; // Mysql username
$password="mypassword"; // Mysql password
$db_name=" hawksvk_mydb001"; // Database name

//Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

?>
------end of code

[flash.engine50]

I have made all. Now it is this same.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ' hawksvk_usr001'@'web7.vital.x10hosting.com' (using password: YES) in /home/hawksvk/public_html/aaa.php on line 8