Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/1130): Host '31.170.160.169' is not allowed to con

[andreasgoette]

When I try to login to the admin panel I got this:



Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/1130): Host '31.170.160.169' is not allowed to connect to this MySQL server in/home/a1601680/public_html/android/admin.php on line 11


Warning: mysqli::autocommit() [mysqli.autocommit]: Couldn't fetch mysqli in /home/a1601680/public_html/android/admin.php on line 12



Warning: mysqli:repare() [mysqli.prepare]: Couldn't fetch mysqli in /home/a1601680/public_html/android/admin.php on line 13



Fatal error: Call to a member function bind_param() on a non-object in /home/a1601680/public_html/android/admin.php on line 14

----------------------

Line 11 - 14 from admin.php:



$db = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die("error to connect db");

$db->autocommit(FALSE);
$stmt = $db->prepare("SELECT * FROM user WHERE login = ?");
$stmt->bind_param("s",$_SESSION['user']);

-----------------------
Lines from dbconfig:

<?
$dbhost='31.170.160.169';
$dbuser='root';
$dbpass='root';
$dbname='android';
?>

Can someone please tell me where the failure is ? - thanks

 

[Walter]

This is a German datanbase forum so please use the German language.
This is not a PHP forum.

Regarding your problems: your arent allowed to connect to the Mysql server (see error message) and your code obviously has no error handling.