Mysql syntax error with phpMyAdmin
I'm trying to import a database and kept getting ERROR 1044 Access denied for user 'username'@'%' to database 'databasename'
So, I've tried to grant permissions to the user by using the command below:
GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
I get the following error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySql server Version for the right syntax to use near 'IDENTIFIED BY 'password' WITH GRANT OPTION' at line 1
I don't have a manual, the MySQL server version is 5.0.90 and phpMyAdmin is 220.127.116.11
Can anyone help point me in the right direction please?