mysql server can't resolve hostname or ipaddress except localhost

[savvyuser]

Hi,

I have installed fedora 6 in my system to act as an intranet and mysql database, network ip config is set to static. I use php to connect mysql. I am wondering why I can't connect mysql using IP address or hostname but It would connect if I set it to localhost. I have assigned an hostname in my server. Version of mysql is 5.0.27.

Is there a way how I can connect using my IP address or hostname?

Thanks....

[mithra62]

do you have port 3306 open on your machine?

[savvyuser]

I disabled my firewall but it give me the same results.

[savvyuser]

I did a command on mysql box: "~]$ mysql -h hostname.domainname -u root -p" and gives me this error:

ERROR 1130 (00000): Host 'hostname.domainname' is not allowed to connect to this MySQL server.

Any idea how I could resolve this issu. Thanks

[ldivinag]

did you add a new user to mysql to attach to the machine via ip addy?

i normally dont use or touch the root account.

i immediately create a second root level account and give that a wider permission and root is set to localhost...

then for each DB, i create an account for it with just enough rights.

try adding a aux account...

[savvyuser]

hi ldivinag,

I did not add any user in mysql database. I use root to access my database. Problem was started when I tried to overwrite records from backup. I checked the logs and no errors were found.

[ldivinag]

root, by default can only connect by localhost.

not any ip addy or host name...

well at least for my 5.0.xNT install...