[chellehman]

I'm very new to web programming with PHP. Im having a problem understanding the connection to the database via the database.php file. Would the host be "000webhost.com"? And I thought the username and password would be what I use to log into mysql but I am getting "Access Denied".

Thank you,

Shelli

[Doug Lochert]

You must setup a MySQL database, username and password before you can use it.
The username will be something like aXXXXXXX_username
The database name will be something like aXXXXXXX_dbname
The MySQL host is something like mysql22.000webhost.com
You can find the exact info in your cPanel under MySQL after you have setup the database.

aXXXXXXX will be your 000webhost account

[chellehman]

Hi Doug - Thank you.
I did already create the database and username/password.
I changed the host to mysql22.000webhost.com and now I am getting the error:
Warning: mysql_connect()[function.mysql-connect: {my ip address} is not allowed to connect to this MYSQL server in {my database.php file}

[Doug Lochert]

mysql22.000webhost.com was only an example.
You must find your "specific" sql server address in your cPanel, under MySQL

[chellehman]

yea - I had already tried that earier - same error. I think I had that part correct in the beginning but kept changing things around because of errors.
My cpanel:
Username axxxxxxx
Password mypswd
Home Root /home/axxxxxxx
Server Name myserver.000webhost.com
IP Address myip

database: 'axxxxxxx_MYDBNAME'
database username: axxxxxxx_MYUSERNM

My database.php file

// Connect to the mysql database.
$conn = mysql_connect("myserver.000webhost.com", "axxxxxxx_MYUSERNM", "mypswd") or die(mysql_error());
mysql_select_db('axxxxxxx_MYDBNAME', $conn) or die(mysql_error());

?>

Error:
Warning: mysql_connect()[function.mysql-connect: {myip} is not allowed to connect to this MYSQL server in {my database.php file}

[Doug Lochert]

Originally Posted by chellehman

// Connect to the mysql database.
$conn = mysql_connect("myserver.000webhost.com", "axxxxxxx_MYUSERNM", "mypswd") or die(mysql_error());
mysql_select_db('axxxxxxx_MYDBNAME', $conn) or die(mysql_error());

Assuming you have all other login info correct, I can only guess that you are still using the incorrect mysql host (highlighted above). This host address is not the same as your website url. It should be like mysql##.000webhost.com as per your cPanel/MySQL info, and not the account info on right side of cPanel showing your website address etc.

If you are usingthe correct MySQL host address, then I can only guess that something is amiss with your IP. Are you using a proxy server to hide your IP?

[chellehman]

OK .. I found the my ## in mysql## by noticing it in the url while logged into phpmyadmin. I made it through step 1 ... now all the rest.
Thank you so much for your help.