I have a php script on my server which is called by my client app to log some information into a remote mysql server.
The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection.
Hi..
Before my main board started smoking my (very simple) file server (Ubuntu 12.04 also) with MySQL support was running just fine.. I used it as a file server for a couple of workstations and had MySQL server running for a few simple databases.. I used to connect to the databases with LibreOffice Base via the java connector and that all worked fine..
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 -p'XXXXXXX'
mysql> CREATE DATABASE foo;
or
echo "CREATE DATABASE foo;";
But no success.
I am using the command line to run the shell script.
# sh create_mysql_database.sh
but all it does is
I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key.
I've been developing these apps just fine on a local machine as has my co worker. We recently moved our work desks so we're now on a different floor of the building, but we only have one router that we're connected to.
Since then, connecting to this one server appears to timeout more often than not.
I have a server which I can connect to via SSH, this server is running mysql. I don't have access via port 3306. Many years ago I got around this using SSH tunnelling but can't get it working at the moment.
I am having problems connecting to remote mysql server. I am running two ec2 instances, one has mysql server configured and the other is from where I need to connect to.
Things I have done...
1. I have modified /etc/my.conf to comment out skip-networking and added bind-address to point to mysql server ip.
2. I made sure port 3306 is open for listening.
3.
I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:
Quote:
Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens
Email this page
