Can't connect to MySQL database via hostinger.com

Viewed 4962

I am trying to connect to mysql database through phpmyadmin on my hostinger.com account, but everytime i signup to my form that created, the data that i entered doesnt go to my database (ive done it on my xampp server, so im sure i didnt do anything wrong) also i have changed the database username, name, host and password from:

<?php

$dbServername = "localhost";
$dbUsername = "root";
$dbPassword = "";
$dbName = "loginsystem";

$conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
?>

to

<?php

$dbServername = "serverexample.hostinger.com";
$dbUsername = "u123456789_username";
$dbPassword = "password";
$dbName = "u123456789_name";

$conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
?>

and still it didnt work, i also tried searching for a database connection tester which is this:

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php

$dbname = 'u123456789_name';
$dbuser = 'u123456789_username';
$dbpass = 'password';
$dbhost = 'serverexample.hostinger.com';

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the db '$dbname'");

$test_query = "SHOW TABLES FROM $dbname";
$result = mysql_query($test_query);

$tblCnt = 0;
while($tbl = mysql_fetch_array($result)) {
  $tblCnt++;
  #echo $tbl[0]."<br />\n";
}

if (!$tblCnt) {
  echo "There are no tables<br />\n";
} else {
  echo "There are $tblCnt tables<br />\n";
}

and it shows me this: http://u920040733.hostingerapp.com/

EDIT: The problem was the server name, it should be localhost XD.

1 Answers

Maybe you database is not accessible from outside your domain

Hostinger Tutorial

Cheers,

Related