Questions tagged [remote-mysql]

22 questions
0
votes
2 answers

How to set up hosts file to allow access to a remote Wordpress database from localhost

My team and I are working on a Wordpress site together. We have one person doing data entry on a live server and the rest of us are working locally. What we would like to do is have our local solutions point to the live server database so that we…
user13286
  • 3,027
  • 9
  • 45
  • 100
-1
votes
0 answers

C# Standalone Application Direct Remote Access MySQL to the Hosting Server

I have done plenty of research in Putty, SSH, DDNS, etc. as per my knowledge to connect dynamic IP from My PC C# standalone application to MySQL Database which hosted. Since it's dynamic IP, I have to whitelist the IP address each time. Can someone…
Romesh
  • 15
  • 3
-1
votes
1 answer

How to run MySQL multiple queries concurrently without waiting the result?

function dbQuery(sql) { dbcon.query(sql, function(err, result) { //imagine the PING to DB server is 1 second. //It would take 100 seconds to complete 100 Queries, if the query is run 1 by 1. }); } for (var i=0; i<100; i++)…
neobie
  • 2,847
  • 5
  • 27
  • 31
-1
votes
1 answer

Not able to connect to remote mysql

my code is as below $dbhost = 'example.com'; $dbuser = 'dbusername'; $dbpass = 'dbpassword'; $dbName='dbname'; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbName); // check connection if ($conn->connect_error) { die("Connection failed: " .…
-1
votes
2 answers

Accessing remote mysql database laravel in server

PHP 7.2.10 Laravel 5.6.39 I have multiple remote mysql database and one mysql database in my server. In my localhost, I am able to connect to all the databases, but in production / testing server, I am unable to connect to remote databases,…
Prafulla Kumar Sahu
  • 9,321
  • 11
  • 68
  • 105
-2
votes
1 answer

Why am I getting MySQL 2003 error: Connection refused error?

I know that this is likely not the right place to ask this question but I am at a loss as to where else to go. I signed up on remotemysql.com to create a (free) database. The data that I store in there means a lot to me, and in the last day or so,…
1
2