3
votes
2answers
110 views

Cannot Establish Remote Connection to MYSQL Database

want to access the MYSQL database remotely but when checking on yougetsignal(dot) com I get a message that port 3306 is closed. Configuration: Fresh Server (Centos 6.4 64 bit with Zpanel installed) ...
-1
votes
0answers
51 views

Can't connect to MySQL server on 'ipaddress' (4) (2003) [closed]

$mysql_host = "myipaddress"; $mysql_user = "user"; $mysql_pass = "password"; $mysql_db = "mydb"; $con = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db); // Check ...
0
votes
0answers
11 views

Mysql access over LAN [migrated]

I have created a java application which connects to a mysql database using the JDBC driver. I have the mysql server running on the same machine as my java application. When i connect to the database ...
-1
votes
1answer
34 views

Can't connect to identically configured remote MySQL server

Where I work, we have a single development server, and a single production server that we manage on-site. When I try to connect remotely to the MySQL on the development server, I get this error: ...
0
votes
3answers
81 views

Remote access forbidden (HY000) to specific mysql client

A MySQL server is located at central.hwcharts.com; it is the master of a basic master-slave replication which replicates toward host0.hwcharts.com, located on a different physical machine which ...
0
votes
1answer
223 views

Unable to connect to mysql on Windows Azure Virtual Machine

I created a virtual machine on Windows Azure. In that I installed MySQL. Every thing works fine on the server. I am not able to connect to MySQL remotely. Steps performed: Installed MySQL Created ...
-1
votes
6answers
692 views

Total newb having SSH tunnel and remote MySQL access problems [closed]

I don't often work with linux or need to SSH tunnel into remote MySQL databases, so pardon my ignorance. I'm using Windows 7 and am needing to connect to a remote MySQL instance on a Linux server. ...
3
votes
2answers
177 views

I can't connect to mysql on a remote server

I'm trying to connect from an Ubuntu server to a RHEL6 server using mysql. I've tried telneting into the server as well as trying to connect with mysql. I've tried commenting out the bind-address but ...
2
votes
3answers
58 views

Accessing mysql DB remotely

I became in charge of a legacy website, which was written by someone else that is now not available, and has no CMS - just pure php and html. It's not written very well, but that's my problem... Some ...
0
votes
1answer
71 views

Accessing remote mysql instance for replica set creation

I'm trying to create a replica set. I have mysql running on the server which will act as my master. However, I'm unable to access that server instance remotely. I have tried all possible ...
3
votes
3answers
3k views

How to allow MySQL Remote Access from a dynamic IP?

I've tried searching for an answer, but can't quite find it. I need to remotely access a MySQL instance through the local MySQL Workbench. The port is turned on (I believe). I can Telnet into it. ...
1
vote
1answer
170 views

IPTables preventing remote connection to MySQL

My table rules: sudo iptables -L --line-numbers Chain INPUT (policy ACCEPT) num target prot opt source destination 1 ACCEPT tcp -- anywhere anywhere ...
0
votes
2answers
2k views

Why can't I remotely connect to MySQL running on my Azure VPS?

I've installed MySQL 5.5 on a Microsoft Azure VPS (2012 Server). I created a user account, told it to allow any host and created an EndPoint on port 3306. I can remote into the VPS using RDP and ...
2
votes
1answer
270 views

MySQL query execution on remote server with output to be saved locally to a file

CMD="use metadata; select * from usernames; select * from personData; select usernames.SNo, usernames.DataTelid, usernames.UName, personData.ActiveInactive from usernames, personData where ...
1
vote
0answers
299 views

Extremely slow response when connecting to remote MySQL database (LAMP Server)

I installed a LAMP server and enabled MySQL remote connections but I'm experiencing really bad response times when connecting to the database remotely from a WordPress install. I've been looking ...
1
vote
1answer
173 views

mysql remote connection [closed]

I spoke with my host supporter to find what is my sql hostname. He said that the only way is add permissions in mysql remote (cpanel) to my actual ip. So the config in heidiSQL for example will be ...
3
votes
2answers
283 views

Remote connect to mysql server?

I've been trying to figure out why I keep getting this error when I try to connect to the MySQL server with the following commands. $~ mysql -u username -h SQLserver -p Enter password: ERROR 1045 ...
0
votes
1answer
467 views

dreamhost | connecting mysql remotely over https

I am trying to Connect to a MySQL Database from Third-Party Programs as mentioned here: http://wiki.dreamhost.com/MySQL (see section: Connect to MySQL Database from Third-Party Programs) I have ...
1
vote
4answers
825 views

shell script - create a mysql database

I am trying to crate a shell script that would: connect to a remote server that has MYSQL running On success run "CREATE DATABASE foo;" So far I tried: #!/bin/bash mysql -h 111.11.11.11 -u root ...
-1
votes
1answer
207 views

Unable to connect to MySql Database on webserver

I have some databases on my shared web server. It was all fine around 45 days back when my website is shifted to another server, all my data is shifted including databases. Now I cannot connect to my ...
1
vote
2answers
2k views

Opening port 3306 for Remote MySQL from VM

I have a CentOS VM on my laptop running a Host-only and a NAT adapters. I'm looking to connect to an external MySQL database on a Bluehost server. According to Bluehost the port 3306 is open. When ...
3
votes
1answer
840 views

How can I connect to MySQL remotely and still keep it safe?

As you know, keeping the MySQL port 3306 open is unsafe. However, I would like to use a good MySQL administration program instead of phpMyAdmin, which requires 3306 port to be open. Of course I can ...
1
vote
1answer
324 views

Allow Remote Connections to MySql Database

I have looked at this Post and it details how you can allow a connection from a remote host to the database. But the line that took me off guard was this: mysql> GRANT ALL PRIVILEGES ON *.* TO ...
0
votes
2answers
751 views

how to connect to mysql running remotely from the jboss

i am facing problem in connecting to mysql running on remote machine from the jboss, Environment setup: 1. Linux machines (Jboss) node1:192.168.1.12 (mysql) node2:172.18.0.1 i have ...
1
vote
2answers
169 views

MySQL Remote Access Security Considerations

I have always used MySQL locally using sockets. Now I need to access a database remotely. How safe is it and what would I need to consider? Is it sufficient to just use the bind-address or should I ...
0
votes
4answers
108 views

MySQL Start Service

Is it possible to, remotely using MySQL, to start a service on the server, or to run any file? What about FTP, can you tell it to run a file? I ask because a developer I work with has killed apache, ...
1
vote
3answers
859 views

Redirecting to alternative ports

I am trying a little bit of security by obscurity here and I want to do the following for a number of services (i.e. MySQL): Let the services definitely run on localhost on their default port Block ...
1
vote
1answer
773 views

How do I remote access mysql server from any host?

I followed 78246 When I do mysql> GRANT ALL PRIVILEGES ON *.* for 'root'@'%' IDENTIFIED BY 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that ...
0
votes
2answers
680 views

How to allow a remote machine to connect to a mysql database?

I have a mysqld server running on a windows 7 machine. How can I allow a Windows Vista machine to connect to this server? I know I need to set some permissions using: grant all privileges to ...
4
votes
5answers
27k views

Remote MySQL connection fails (10060)

When I am trying to connect to a MySQL database from a remote computer I get a prompt saying: Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Can't Connect to MySQL server on 'XXX.XXX.XX.XX' ...
0
votes
1answer
626 views

PHP and MySQL remote host

How to run a PHP script which needs to connect to a MySQL at a remote host? When I run this: $dbHost = "example.com"; $dbUsername = "root"; $dbPassword = "pass"; $dbDatabase = ...