MySQL: How do you enable remote access to a mySQL database if the database is on a remote server?

The only way I discover how to edit the actual DB is definitely using phpmyadmin.There has to be anyway to let remote use of the DB like that Or this specific there other wayss to permit remote access that the DB is hosted on the remote machine

Modify the particular IP information reported by your scenario.

Move # ONE PARTICULAR:Login Implementing SSH (if node is outside computer data center)

1st, login more than ssh to help remote MySQL data source server:

ssh usermysql.nixcraft.i

Move # A COUPLE OF:Edit my.cnf File

Once connected you should edit that MySQL node configuration record my.cnf using a text editor for example vi.

* If you work with Debian Linux file is situated at /etc/mysql/my.cnf location
* If you work with Red Head wear Linux/Fedora/Centos Linux file is situated at /etc/my.cnf location
* If you work with FreeBSD you’ll want to create any file /var/db/mysql/my.cnf

Modify /etc/my.cnf, go:
# vi /etc/my.cnf
Move # SEVERAL:Once report opened, get line in which read because follows

mysqld

Make sure line skip-networking is usually commented (or get rid of line) along with add following line

bind-address=YOUR-SERVER-IP

As an example, if ones MySQL node IP is actually 65.FITYFIVE.55.2 and then entire block need to be look such as as employs:

mysqld
customer = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
opening = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
terminology = /usr/share/mysql/English
bind-address = 65.FITYFIVE.55.2
# skip-networking
….
..
….

Exactly where,

* bind-address:IP handle to emergency to.
* skip-networking:Dont listen for TCP/IP connections in any respect.All connections with mysqld need to be made by way of Unix sockets.This solution is important for systems where only local asks for are helped.Since you should allow online computer repair connection this specific line needs to be removed from my.cnf as well as put that in brief review state.

Step# 5 Save along with Close that file

Restart the mysql node, enter:
# /etc/init.d/mysql restart
Step # YOUR FIVE Grant use of remote IP address

Go to mysql device:
BUCK mysql -u actual -p mysql
Grant use of a fresh database

If you need to add a fresh database referred to as foo regarding user club and remote pc help IP 202.54.15.20 then you should type the following commands on mysql> induce:mysql> DEVELOP DATABASE foo;
mysql> SCHOLARSHIP ALL AT foo.* TO HELP bar’202.54.15.20′ RECOGNIZED BY ‘PASSWORD’;
When will i Grant Usage of An Prevailing Database

Let all of us assume that you’ll be always creating connection from remote IP referred to as 202.54.15.20 with regard to database identified as webdb with regard to user webadmin, To grant use of this IP handle type the following command From mysql> quick for existing database, enter in:
mysql> up-date db set Host=’202.54.15.20′ exactly where Db=’webdb’;
mysql> up-date user arranged Host=’202.54.15.20′ exactly where user=’webadmin’;
Move # 5:Logout of MySQL

Kind exit get to logout mysql:mysql> exit
Move # 6TH:Open port 3306

You should open TCP opening 3306 implementing iptables or maybe BSD pf firewall.
YOUR sample iptables principle to amenable Linux iptables firewall

/sbin/iptables -A INSIGHT -i eth0 -p tcp –destination-port 3306 -j ACCEPT

OR just allow remote computer repair connection out of your web device located on 10.YOUR FIVE.1.3:

/sbin/iptables -A INSIGHT -i eth0 -s TWELVE.5.JUST ONE.3 -p tcp –destination-port 3306 -j ACCEPT

OR just allow remote computer repair connection out of your lan subnet 192.168.JUST ONE.0/24:

/sbin/iptables -A INSIGHT -i eth0 -s 192.168.JUST ONE.0/24 -p tcp –destination-port 3306 -j ACCEPT

Ultimately save just about all rules:
# assistance iptables save
YOUR sample FreeBSD / OpenBSD pf principle ( /etc/pf.conf)

go in at $ext_if proto tcp out of any to help any port 3306

OR let only access out of your web machine located from 10.YOUR FIVE.1.3:

go in at $ext_if proto tcp out of 10.YOUR FIVE.1.3 to almost any port 3306 flags S/SA synproxy state

Move # SEVERAL:Test it

Out of your remote process or ones desktop type the following command:
BUCK mysql -u webadmin Ch 65.FITYFIVE.55.TWO Cp.