4

Problem with remote access to Mysql Server

view full story
linux-howto

http://nixcraft.com – 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. Tried connecting remotely using $ mysql -u <user> -h <mysql-server-ip> -p No luck yet :( Any clues on what's going wrong? (HowTos)

suki's picture
Submitted by suki on 12/09/2010 – Made popular on 12/09/2010

Stories similar to Problem with remote access to Mysql Server

hi I am trying to connect mysql server running on amazon linux instance but did not succeeded yet .

Scenario : i installed mysql server in amazon's ec2 instance .

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 (28000): Access denied for user 'username'@'myIP' (using password: YES)

I've done the following: Port is open in the firewall other wise I wouldn't get the error it'd just timeout. MySQL server not run

Connecting to Mysql server 1 year 7 weeks ago

I'm having some issues connecting to a mysql server remotely.

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 using cPanel and the Config Server Firewall (CSF), and I need to provide remote access to an MySQL database on the server. I have properly configured a user to connect from a remote location, but I can not get access to MySQL. When reviewing, it appears that the firewall is blocking access.

I'm running a couple of projects which consume alot 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 numbers grow.

Currently i'm using 1 server with nginx, php-fpm and mysql (dual xeon, 24 GB ram, SSD's) and connecting to mysql through a local socket.

Would i experience a "performance drop" if i had a r

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.

MySQL Workbech Wont Connect 2 years 42 weeks ago

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

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