Not sure if this is the correct forum, but I couldn't find a better one.
I have MySQL up and running. I created a new user, and attempted to connect using Hibernate. However, I keep getting Access Denied errors. I can't connect using the MySQL GUI Tools either with that user.
I've run into the same problem with another MySQL database. I'm trying to connect the GUI Tools from another machine, and it won't let me. I did some googling and tried running the following logged in as root.
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'pass" WITH GRANT OPTION;
AFAIK, that will allow me to connect to the db from anywhere. However, I keep getting back the same error.
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)