0
votes
1answer
295 views

access mysql remotely from raspberry pi? [closed]

I am using ubuntu 13.10 and I connect the raspberrypi with my laptop using ethernet cable. Now MySql Server is run on my laptop machine. Machine IP's IP Address (laptop machine) : 10.42.0.1 IP ...
0
votes
1answer
228 views

Cant connect remotelly to MySQL Server from DigitalOcean

I've just finished setting up my Server on Digital Ocean (Ubuntu 12.10 x64) using nginx, but i want a separate MySQL Server to decrease the load to the web server. The problem is, im unable to ...
-1
votes
1answer
37 views

How to allow remote connection to MySQL only for specific accounts in CentOS VPS?

I have a CentOS VPS. Port #3306 for MySQL is open for all customers, and they can connect to their databases remotely. As this can be a cause of security issues, I would like to stop all remote ...
0
votes
0answers
311 views

Connect to MySql remotely from another server

We're trying to migrate domains from an old dedicated server (11.11.11.11) to a new dedicated server (22.22.22.22) and we think that the best way to do it without downtime is to copy scripts to the ...
0
votes
1answer
266 views

Migrating local databases to new a Plesk server pointing to external MySQL server, databases are created locally

First of all, this problem is not the same as the one referenced at When migrating to Plesk 11 database is created on localhost not DB server. This one happens when we try to migrate clients from an ...
0
votes
1answer
162 views

How to dump remote database without using mysqlDump

I have a similar problem from this question How to dump remote database without mysqldump? How ever when I run ssh -f L 3306:localhost:3306 user@remoteserver -N I am receive the following error ...
0
votes
1answer
346 views

Unable to remote into mysql server on Amazon ec2 windows instance

I'm trying to connect to MySQL server from my dev machine(win 7) using 'Toad for MySQL'. MySQL server is located on AMI windows instance(amazon ec2). I have had success earlier with dedicated servers ...
0
votes
1answer
4k views

MySQL remote access not working - Port Close?

I am not able to get a remote connection established to MySQL. From my pc I am able to telnet to 3306 on the existing server, but when I try the same with the new server it hangs for few minutes then ...
0
votes
0answers
225 views

Remote mysql server slow

I need some help on speeding websites loading. I have two virtual machines created on my ESXi host. Thay are both on public IP addresses and that is how they communicate. On one virtual machines I ...
1
vote
1answer
274 views

Mysql remote connections logging

I need to allow remote connections to my mysql server running on latest stable CentOS. I don't like this idea at all so I want at least to collect as much relevant information as possible. To be ...
2
votes
3answers
787 views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
0
votes
2answers
1k views

I cannot find the file 'my.cnf ' to change 'bind-adress' to allow remote managing of MySQL database

I want to update some data to a MySQL remote server. I have conexion between the server and the client through VPN and it works. But I can't manage server's databases from the client. I've read that ...
1
vote
2answers
607 views

Cherry pick and import tables from remote mysql database into local?

I have a local mysql database called intranet_production, and on a remote server (which I have root access to the server and mysql) there is a database called 'extranet`. Within the remote extranet ...
2
votes
0answers
1k views

Trying to connect phpMyAdmin to remote mySQL server ( 2002: can't connect )

Trying to get phpMyAdmin to talk to a remote mySQL server. The config is below and there is already a user set up in mySQL DB to be able to log in from the specified host that PMA sits on. Hosting is ...
1
vote
2answers
362 views

Performance: mysql socket vs. mysql remote

I'm running a couple of projects which consume a lot of MySQL power (10'000 qps in peaktimes)...now I'm wondering what would be the best setup in order to keep it fast and smooth even if the user ...
0
votes
3answers
110 views

should php be installed on apche web server or mysql database server

Setup: Two separate boxes: Fedora 15, Apache, PHP and PHP modules Fedora 15, MySQL I am unable to make a connection to mysql from Apache web server. <?php echo "<br>begin ...
0
votes
2answers
1k views

How does the MySQL connection on remote server works?

When I connect to my MySQL database locally I use: $host = 'localhost'; $db = 'myDB'; $user = 'root'; $pass = ''; When my site resides on remote server I use the following parameters to make a ...
0
votes
3answers
1k views

Connecting to mysql server remotely via dyndns.org

I have a mysql server which is accessed locally by several computers on the network through a static ip at 192.168.1.# . I need the mysql server to be accessed from our web servers so that I can run ...
2
votes
2answers
1k views

App server takes a long time to connect to MySQL Server

I have a strange problem that I couldn't figured out and would like some expert advice to handle this thing. My database is running on a seperate machine My application server tries to connect to ...
1
vote
4answers
713 views

Tuning a remote MySQL server?

I am having to tune a client's MySQL server on a Windows machine but I only have access to the MySQL cli and some MySQLAdmin cli functions. I can't see how I can mysql-bench either because it needs to ...