mysql-connection problem

[prudhviy]

i hav written a php script which has a mysql connection...
but it is giving the message cannot connect
intially selinux prevented it.....
then when i tried this command
#mysql --user=root --password=***** --host=ipaddress
it is giving the message...
ERROR 1130 (00000): Host '172.16.119.22' is not allowed to connect to this MySQL server
help me plzzzz
regards

[brunson]

If it's running on the same box, then don't specify --host, and it will make a local socket connection. If it is not running on the same host, or you need to use a network transport even though you're local for some reason, then issue this command:

grant all on *.* to root@'172.16.119.22' identified by 'yourpassword';

If you need to do grants via your application:

grant all on *.* to root@'172.16.119.22' identified by 'yourpassword' with grant option;