Hello, i am using plesk,phpmyadmin on my dedicated server and i cannot assign user to database:

Error

SQL query:

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON mydatabasename . * TO 'databaseusername'@'localhost'
IDENTIFIED BY 'mypasword';

MySQL said:

#1044 - Access denied for user 'myusername'@'%' to database 'mydatabase'

please..

According to what you posted, that's an issue with authentication. What did you enter for your username?