Connecting to online MySQL database from localhost

Question

How can I connect to MySQL database online from localhost using php?

I have read through all I could laid my hands on but to no avail. I read through Connect to an online MySQL database from localhost, Connect to server database from localhost, Connect to server database from localhost and some as well but none of them helped.

I tried

$dbhost = 'infonetemonitor.com'; //$db['host'];
$dbuser = '****';//$db['user'];
$dbpass = '****';//$db['pass'];
$dbname = 'info1_quiz';//$db['dbname'];

//Mysqli
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if (mysqli_connect_errno()) {
    printf("MySQLi connection failed: ", mysqli_connect_error());
    exit();
}

But this error was generated:

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'info1_senetorial'@'41.58.56.26' (using password: YES) in C:\wamp64\www\COSTMI\includes\liveconnect.php on line 10

I thought it could be due to the fact that I didn't add an ip to Remote MySQL so I did but still nothing change.

In the database, I tried to grant privileges

GRANT ALL PRIVILEGES ON info1_quiz.* TO 'info1_senetorial'@'41.58.56.26' WITH GRANT OPTION;

but this error was displayed:

MySQL said:

1044 - Access denied for user 'infon10'@'localhost' to database 'mysql'

How can I go about it?

Possible duplicate of Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) — Obsidian Age
– Obsidian Age, Commented Mar 13, 2019 at 2:02
can you add the contents of mysql.user to the question? (only user name and host needed) MySQL is picky about the ordering of entries in that table — Joni
– Joni, Commented Mar 13, 2019 at 3:02

Tej Parekh · Accepted Answer · 2019-03-13 02:16:03Z

0

Try to replace the host name with the Host IP address and check again. this should allow you to connect to the DB. If you want to connect with the domain name then you should configure MySQL to understand with the domain name associated in the apache.conf file.

answered Mar 13, 2019 at 2:16

Tej Parekh

11 bronze badge

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

1 Comment

Olajumoke Ademilade Over a year ago

I tried it but still getting Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'infon10_senetorial'@'41.58.104.52' (using password: YES) in

Collectives™ on Stack Overflow

Connecting to online MySQL database from localhost

1044 - Access denied for user 'infon10'@'localhost' to database 'mysql'

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1044 - Access denied for user 'infon10'@'localhost' to database 'mysql'

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related