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've changed data directory in /etc/my.cnf.
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.
I have installed mysql and phpmyadmin via, yum. I get the message
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
The server is not responding (or the local server's socket is not correctly configured).
The problem though, is with mysql itself.
# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job failed.
Hi,
I have install MySQL serve in Fedora 16 32 bi distro that I have on my pc, but I can't start MySQL from command line. Can you please help?
I am hosting a mysql server in a debian 6.0.4 server hosted in linode, the new data is frequently written into the mysql server using R, about 30-40 "write" per minute, about 7 hours a day, 5 days a week.
Recently I found that the mysql server seem to down frequently, always give me error that mysql server cannot be connected through socket.
I have 2 servers, both running Ubuntu server 11.10.
The first server runs Apache and PHP and it connects to a Mysql database on the second server.
The problem is slow mysql response on the second server.mysql logs does not show any errros other than: 120526 12:56:27 [Note] Plugin 'FEDERATED' is disabled.
It seems I have a conflict of mysql versions, one installed with MAMP in the Applications folder and the other installed with brew install mysql2. I created with the mysql related to MAMP, a gitlab mysql user and a gitlabhq_production database. It worked fine.
Suppose now I have a user on my os called 'git'.
My server hangs everyday
So i checked system health - process manager in whm
there was a command given below
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306
see this image
here this mysql command process is taking
Email this page
