When bind-address in my.cnf is set to a value other than 127.0.0.1 MySQL will receive remote connections.

However, this error (1045) implies that you are using a user name that is not mysql.user table:

Access denied for user foo@192.168.254.64

Now this error (2003) implies that your user name is in the mysql.user table but the Host value is not found in mysql.user.Host:

Can't connect to MySQL server on '192.168.254.64'
Access denied for user

In the latter case, you can add the name user name for the host 192.168.254.64 or you can leave the Host blank which should direct MySQL to look up the valid host names in the mysql.host table.

In phpMyAdmin (for Debian and others), the Add New User > Login Information > Host: field provides Use Host Table option.