mysql

[Marcel Kunath]

I got trouble with a mysql user. User is in mysql.user for localhost:

| Host      | User    | Password         | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv
| localhost | username | 01c7a9156ca2cbd7 | Y           | Y           | Y
    | Y           | Y           | Y

User is in mysql.db for a created database:

| Host      | Db       | User    | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
| localhost | database | username | Y           | Y           | Y           | Y
          | Y           | Y         | Y          | Y               | Y
| Y          |

Trying to access it though it says:

mysql -u username -p database
Enter password:
ERROR 1045: Access denied for user: 'username@localhost' (Using password: YES)

What did I forget to give permissions for?

-- Marcel Kunath

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

 Montie House Network            Greater Lansing Linux Users Group
  http://www.montiehouse.com      http://www.gllug.org

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*