MyHostPal

Question by : how to connect database file on hosting site correctly?
I have got a php log in and registration script from the link :-

http://php-login-script.com/install.htm

I have got also an installation instruction.I followed this,but I cannot access to the site.My site URL is miraz.site40.net

I have uploaded dynamic script on my hosting site but when I go to access to the site using my site URL,the page shows error message for connectig database incorrectly.It also shoows the server does not get the connection to the database.

Please tell me the step by step process to set up and connect database correctly.

The script is very simple.it’s only to register and log in function.

To run the site,I have done the following work:-

1.At first, I create a MySQL database. The information is

FTP host name miraz.site40.net
FTP username : a6886183
FTP password: miraz12
MySQL database name: a6886183_ mizan
MySQL user name: a6886183_ hi
Password for MySQL user: samoiu5

2.I enter into php admin and I copy and paste dbsql.sql on SQL of database to create users table and your admin login. The tables are created.
3.I Open dbc.php and set values inside the quotes for my mysql settings.The values I set were the following
define (“DB_HOST”, “miraz.site40.net”); // set database host
define (“DB_USER”, “a6886183_ hi”); // set database user
define (“DB_PASS”,”samoiu5″); // set database password
define (“DB_NAME”,”a6886183_ mizan”); // set database name

4. (i) I Downloaded recaptcha php library (http://recaptcha.net/plugins/php/), unzip and copy the single php file recaptchalib.php into login script folder.
(ii) I went to recaptcha.net, register a free account, and I got public and private keys. I Made a note of that and set it here inside dbc.php

$ publickey = ” 6Lew1b4SAAAAAK1Usr_AoE9587gyh5Y3putB2fwy ”
$ privatekey = ” 6Lew1b4SAAAAAIyOtg0VKyVYcYAF7XTE4f6KVXSx “;

I do these.But when I click on the link,I cannot access to the site.It shows error message.I also tried to access to the admin panel which was provided with the instruction but I cannot access.

http:// miraz.site40.net:2082/3rdparty/phpMyAdmin/

Best answer:

Answer by rbjolly
The host name for your database (define (“DB_HOST”, “miraz.site40.net”)) is most likely wrong. I’ve never seen a hosting provider make the database host name the same as the site name. You need to double check the value.

And you also need to ask yourself why you’re posting all your access info to the public.

What do you think? Answer below!