Connect online mysql database with the local xampp server using php

Question

I tried using the following code in php:

<?php
$servername = "www.psgcirdask.com";
$username = "xxx"; //hidden for security purpose
$password = "password";
$dbname = "psgcilqh_calibration";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

  $sql = "SELECT * FROM brands";
  $result = $conn->query($sql);
$conn->close();
?>

I got an error:

Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'xxx'@'157.51.147.43' (using password: YES) in C:\xampp\htdocs\justshawarmapos\checkthedatabase.php on line 9 Connection failed: Access denied for user 'xxx'@'157.51.147.43' (using password: YES)

But i use the same username and password to connect to my database in my website.I am getting this problem only when i connect using local server.

Your web site does not connect from 157.51.147.43, does it? — Álvaro González
– Álvaro González, Commented May 30, 2018 at 12:52

Gabriel · Accepted Answer · 2018-05-30 12:50:26Z

1

You have to enable remote access in your mysql database.

Check this link

For hostgator

edited May 30, 2018 at 12:50

answered May 30, 2018 at 12:39

Gabriel

9457 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Nikeshh Vijayabaskaran Over a year ago

How do i do that?

Fabian S. Over a year ago

@NikeshhBaskaran maybe serverfault.com/questions/52794/… helps

Nikeshh Vijayabaskaran Over a year ago

My website is on hostgator.How to do it there?

Gabriel Over a year ago

That's even easier from hostgator cpanel : google.co.in/url?sa=t&source=web&rct=j&url=https://…

Nikeshh Vijayabaskaran Over a year ago

I added my ip address 157.51.171.108 in the remote access but still i get the same error

|

Giuseppe Albrizio · Accepted Answer · 2018-05-30 12:44:53Z

0

Check if all the infos provided are correct especially the servername then try to figure out if you have the right permission to access that database with that user!

answered May 30, 2018 at 12:44

Giuseppe Albrizio

4303 silver badges16 bronze badges

Collectives™ on Stack Overflow

Connect online mysql database with the local xampp server using php

2 Answers 2

11 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related