I want to give MySql access to a Raspberry Pi on my local network.

Let's say the Raspberry Pi is at 192.168.1.10 and the server pc is at 192.168.1.100 (Fedora 16)

My my.cnf at 192.168.0.100 file is as follows

[mysqld]
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld]
bind-address = 192.168.0.100
bind-address = 127.0.0.1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I have also gone into the firewall and opened port 3306 and opened it on the router.

I have issued a grant similar to:
grant select, insert, delete on mydb.* to pi@192.168.0.10;

When I try to connect, I get this:

mysql --host=192.168.0.100 --user=pi@192.168.0.10
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.100' (111)


I have installed MySQL Client on the Pi (5.5.28)
Fedora Box mysql-5.5.23-1.fc16.x86_64
What am I forgetting to do or doing wrong?

You need to setup your port forwarding on your router more than likely. Can you confirm that the system is listening on :3306? If taht is the case then setup the forwarding on your router so the requests get there.

Netstat says I have a server listening on that port for 127.0.0.1 and I can do the following:
mysql -u user -P 3306 -p
And it connects to my server, so I am assuming that it does use port 3306

I have a netgear router. On my Block Services Page I have the following:

Block Services

Services Blocking
Never
Per Schedule
Always

Service Table
# Service Type Port IP
1 MySQL 3306 all

I also have on the Port Forwarding Page:
# Service Name Start Port End Port Server IP Address
1 MySQL 3306 3306 192.168.0.100

And still no mysql service from 192.168.0.100 is available

You only have to configure port forwarding on the router if trying to access a service from outside your LAN.

Did you restart mysql so the changes will take effect? If netstat only indicates mysql is listening on 127.0.0.1 then that is the reason for the error.

I am not sure how to read this, but:
I have restarted mysql several times.

Netstat MySQL Line says:

tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN

IPTables is set up as

[root@draco ~]# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT icmp -- anywhere anywhere
ACCEPT all -- anywhere anywhere
ACCEPT udp -- anywhere anywhere udp spt:svrloc
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:domain
ACCEPT udp -- anywhere anywhere state NEW udp dpt:domain
ACCEPT udp -- anywhere anywhere state NEW udp dpt:ipp
ACCEPT tcp -- anywhere anywhere [root@draco ~]# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT icmp -- anywhere anywhere
ACCEPT all -- anywhere anywhere
ACCEPT udp -- anywhere anywhere udp spt:svrloc
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:domain
ACCEPT udp -- anywhere anywhere state NEW udp dpt:domain
ACCEPT udp -- anywhere anywhere state NEW udp dpt:ipp
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ipp
ACCEPT udp -- anywhere anywhere state NEW udp dpt:ipp
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-ns
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-dgm
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:netbios-ssn
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:microsoft-ds
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-ns
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-dgm
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:https
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ssh
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:16514
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:http
ACCEPT udp -- anywhere 224.0.0.251 state NEW udp dpt:mdns
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:mysql
ACCEPT udp -- anywhere anywhere state NEW udp dpt:mysql
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:xmpp-client
ACCEPT udp -- anywhere anywhere state NEW udp dptark-agent
ACCEPT tcp -- anywhere anywhere state NEW tcp dptostgres
REJECT all -- anywhere anywhere reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target prot opt source destination
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT icmp -- anywhere anywhere
ACCEPT all -- anywhere anywhere
ACCEPT tcp -- anywhere draco.oldboy.com state NEW tcp dpt:mysql
REJECT all -- anywhere anywhere reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target prot opt source destination state NEW tcp dpt:ipp
ACCEPT udp -- anywhere anywhere state NEW udp dpt:ipp
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-ns
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-dgm
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:netbios-ssn
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:microsoft-ds
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-ns
ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-dgm
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:https
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ssh
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:16514
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:http
ACCEPT udp -- anywhere 224.0.0.251 state NEW udp dpt:mdns
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:mysql
ACCEPT udp -- anywhere anywhere state NEW udp dpt:mysql
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:xmpp-client
ACCEPT udp -- anywhere anywhere state NEW udp dptark-agent
ACCEPT tcp -- anywhere anywhere state NEW tcp dptostgres
REJECT all -- anywhere anywhere reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target prot opt source destination
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT icmp -- anywhere anywhere
ACCEPT all -- anywhere anywhere
ACCEPT tcp -- anywhere draco.oldboy.com state NEW tcp dpt:mysql
REJECT all -- anywhere anywhere reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

MySQL appears to be only listening to 127.0.0.1.

Try removing the "bind-address = 127.0.0.1".

If that works remotely, but not locally try "bind-address = 0.0.0.0", or remove the bind-address entirely.