Questions tagged [remote-mysql]
22 questions
1
vote
1 answer
MySQL port showing close after changing bind-address to server's private address
I am using Digital Ocean's droplet I want to access my database though my workbench. Earlier I was using Google's compute engine with same settings like changing bind-address to server's private-ip and then creating user with same ip as a host.…
Dharmeshkumar
- 11
- 4
1
vote
5 answers
How do I connect my python code to a mysql database hosted on the internet?
I have made a free account on https://www.freemysqlhosting.net which provides a free mysql database hosting facilities. I have created a database there, but I don't know how to connect to it from my python code on VSCode.
As of now, I am using a…
Veeraja Veeraesh
- 194
- 10
1
vote
0 answers
How to connect my flutter app to remotemsql.com database
I am working on a flutter app that needs to connect with a remote mysql db on remotemysql.com. I have created the db and tables on remotemysql.com but I don't know how to connect the flutter app with the db. I read some tutorials on how to do this…
omokehinde igbekoyi
- 926
- 9
- 16
0
votes
0 answers
remote database host not reacheable from cpanel in codeigniter 3
I have a codeigniter 3 application hosted on cpanel. The database is hosted remotely and I can access it via public ip on localhost without any issue. I have added the app on cpanel and added the remote mysql host ip but i get the error below:
A…
Nehemiah Cheburet
- 17
- 5
0
votes
1 answer
connecting to a remote mysql database (NodeJS)
function checkMYSQL()
{
var mysql = require('mysql')
var connection = mysql.createConnection({
host: "------",
user: "-----", //
password: "-----", //
database: "-----",
})
var resultsss = connection.connect((err)…
Amit Morad
- 1
- 1
0
votes
0 answers
Remote MySQL option is not showing in cpanel
Cpanel doesnt have Remote Mysql option. How to enable this option?
Cpanel sould have Remote Mysql option like this:
JHM69
- 3
- 4
0
votes
0 answers
remotemysql.com cannot connect with python neither on the site manually
I try to reach to my remotemysql database with my Python script which worked fine first, now it doesn't connect anymore so I went to remotemysql.com/login.php but it gives an error
Connection failed: SQLSTATE[HY000] [2002] No such file or…
sub joel
- 1
- 3
0
votes
1 answer
Constructor failed on creating a new PDO connection
I'm trying to access a remote MySQL server. I created a user in the remote server and granted all the remote privileges to all hosts.
This is my code for connecting to database:
Amirition
- 328
- 5
- 22
0
votes
0 answers
using replit.com and remotemysql.com
enter image description hereI'm trying to connect replit.com (the cloud based IDE I'm using) and database from remotemysql.com. I only get "HTTP ERROR 500". How do I fix this? Any reply may help. Thanks.
Here is my code on mysqli_connect.php file (I…
Amanda Ip
- 1
- 2
0
votes
0 answers
Connect Google Sheets scripts to MySQL
I'm just learning to use Google Sheets scripts, and trying to log into my MySQL database, below is my code
function readData() {
var conn = Jdbc.getConnection('jdbc:mysql://hostname(or using IP Address):3306/database_name',username,password);
…
JimmySo
- 1
0
votes
0 answers
Too many connections on remotemysql.com
I have been using a database hosted on remotemysql.com for few months and used it with a node.js discord bot.I've tried to connect to the database recently with php but forgot to close the connection. No I can't connect anywhere to the…
Joren Nagels
- 1
- 2
0
votes
1 answer
Remote MySQL Database Blocked
I have a Java program that connects to a remote MySQL database to store information about students. The program works perfectly on my home network, but when I'm connected to my school's network the connection times out with 100% packet loss. I'm…
danelliott
- 150
- 1
- 7
0
votes
1 answer
is there an easy way to sync a sqlite db to firebase json?
I have an android application which need to be updated at code level and upgrade features. long story short the app useas a sqlite DB to store data but now it needs to store data in the cloud. is there an easy way to sync the sqlite stored data to…
Kike_mskt
- 45
- 1
- 6
0
votes
3 answers
Connect and insert data from my computer to server's MySQL DB table with the help of C#.NET
I want to connect with a server's MySql DB(cpanel) . Though there are no errors every time I'm getting a message for Messegebox : unable to connect to any of the specified any of the MySql hosts.
using MySql.Data.MySqlClient;
connString =…
Md. Ariful Islam
- 54
- 6
0
votes
1 answer
Issue with connecting my express server on heroku to the remote mySQL
I'm trying to deploy my express server on Heroku which needs to connect to the remote MySQL database.
I used 'heroku config:add DATABASE_URL=mysql://dbusername:dbpassword@databasehostIP:databaseserverport/databasename with the correct information…
pouyan zarbafian
- 9
- 1