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 got two Debian 6 servers - one for web and one for the database..
How can I connect through the local area network?
On both servers I have permanently changed the hostnames
/etc/hostname
/etc/hosts
web => web-server
db => db-server
In the privileges in mysql I have set the root user to accept requests from web-server (instead of localhost) and from the web-server I connect to db-serv
in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc...
in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this:
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Lost connection to MySQL serve
Brand new server, brand new MySQL 5.5 install on Ubuntu 12.04.
I can log in to the database as root from the command line.
I can log on via Navicat MySQL or Sequel Pro as root on port 3306 from my Mac.
I cannot log in using an SSH tunnel to the server and then to the database as root. I have tried both localhost and 127.0.0.1 as server for the local connection part. My password is fine.
As you know, keeping the mysql port 3306 opened is unsafe - but I would like to use a good mysql administrative program instead of phpmyadmin, which requires 3306 port to be opened.
Of course I can allow only my ip address to connect to 3306 port using ipfw, but the problem is that my IP address change itself every 24 hours, so I would have to add a new rule for every IP address...
Isnt there an
I have a standard MySQL Server running on Red hat 5.7. I have edited /etc/my.cnf to specify the bind address as my server's public IP address.
I am trying to install openstack on my local machine. I am following the documentation from devstack.
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 have a VPN with public and private subnets; I am considering only public subnet for now.
The node 10.0.0.23, I can ssh into it.
Email this page
