MySQL Remote Connection

Hi all,

I've just solved my mysql remote connection problem, and I thought that this may help someone else.

Let me begin with MySQL or phpMyAdmin:
* Create a new user (by your root account) or use existing user. Select Any Host (write % to textbox and it means "from everywhere") selection or write specific IP (you would like to connect remotely from) to that textbox.
* Consider giving global privileges for this user (check all if you don't mind)
* Now, you can also give access right to this user for specific databases or specific tables.
Let's continue with CWP:
* You also need to add bind-address=0.0.0.0 (from everywhere or write your IP address for connection) in my.cnf (it may be named as my.ini) file. You can also use CWP's "SQL Services" > "MySQL Configuration" page for doing this configuration.
* Restart mysql service.
* Add firewall rule for giving permission to the IP with "IN" "TCP" "3306" (mysql specific port or without port number in order to open all ports for that IP). You can use CWP's Security > Firewall Manager
* Restart Firewall then.
* Check your firewall rules.
Also look at:
* If you use firewall service from 3rd party, ask them there is a block or not.

This is the way. Great tutorial. I just want to add that for some reason from time to time CWP recreate de config on the firewall. So once in a while i always have to came back and add 3306 port on csf.conf as you mention ( on firewall manager)

Perfect.
This tutorial worked like a charm.
CWP7 rocks!!!

Thank ozgur

The OP's procedure is highly problematic in terms of security.

No one should be opening up their server to the entire world in this fashion.

Do not follow the OP's instructions. Do not open port 3306 to all.

Agreed!