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:
Host 'localhost.localdomain' is not allowed to connect to this MySQL server
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?