MySQL remote access...

MySQL remote access...

rafaht Offline

Sentora Member

OS: Ubuntu 14.04
Version: 1.0.0
Server: VPS

Posts: 78
Threads: 17
Joined: Aug 2014
Reputation: 2
Sex: Undisclosed

Thanks: 15
Given 7 thank(s) in 6 post(s)

RE: MySQL remote access...

02-25-2015, 05:45 AM

Hmm, for me has necessary one more thing:

Code:
sudo vim /etc/mysql/my.cnf

Find this:

Code:
bind-address=127.0.0.1

Change for this:

Code:
bind-address=YOURSERVERIP

Change YOURSERVERIP for the your server IP. Save and quit:

Code:
:x

Restart the MySQL:

Code:
sudo service mysql restart

Remember: the port 3306 needs to be open at firewall.

Find

Thanks given by: pixelbat

« Next Oldest | Next Newest »

Messages In This Thread

MySQL remote access... - by pixelbat - 02-25-2015, 03:26 AM

RE: MySQL remote access... - by rafaht - 02-25-2015, 05:45 AM

Users browsing this thread: 2 Guest(s)

Forum