I recently used navicat to manage my mySQL databases. I was messing around and creating a java interface to access the database. From a command line I can do just fine but when I boot up the script I get the following error:When I created my database in Navicat I called the connection name: localhost and the Host Name/IP Address was also called localhost. I tried to find out about the error and from what I've seen Linux has an issue using localhost. Is this true and I have to change the localhost to use 127.0.0.1? Or is there something else going on that could be causing this issue?

MySQL can be very particular about the hostnames used. I'd suggest you look around for any area n configuration of the client where localhost.localdomain maybe used.

I think there's a few different ways you could attack this one. Try one of these...

1. Type "hostname" at the shell prompt. If it comes back as "localhost.localdomain" rather than "localhost" type "hostname localhost" at a root prompt. This solution won't be persistent after a reboot.

2. Type "hostname" at the shell prompt. If it comes back as "localhost.localdomain" rather than "localhost" change your /etc/hosts file to read "127.0.0.1 localhost locahost.localdomain"

3. Check /etc/sysconfig/network and see what the HOSTNAME parameter is set to. If it's "localhost.localdomain" set it to "localhost"

4. The row in the mysql.user table probably says "localhost" in the host column. You could try changing that to "localhost.localdomain" or adding a duplicate of the row and setting host to "localhost.localdomain"