Content of /etc/my.cnf file:
Code: Select all
[mysqld]
skip_name_resolve
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port=3306
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Code: Select all
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql
ACCEPT tcp -- 1.1.1.2 1.1.1.1 tcp dpt:mysql
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination
I created two users, both at '%', so when I access the server via putty, I can log into MySQL with those users and do what they are allowed to do, so it's not a privileges problem, I think.
The port is definitely listening:
Code: Select all
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2694/mysqld