Can't Install SQL database for drupal. showing error/

[genxspirit40]

i am installing drupal 6.20 but the sql database is creating problems. i cant use a database command on sql database in order to make drupal work. Sql is not permitting user to access the database. the command is GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';

please help to solve this issue.

[descalzo]

If you are installing it manually, you first use cPanel --> MySQL Databases to create your database, create your database user (write the password down), and add the database user to the database, making sure to check the ALL PERMISSIONS box when it comes up.

The database and database user names are of the format yourcPanelUsername_foo (cPanel adds your cPanel username) , not just foo

Use that database when you run the Drupal install.

Note that Softaculous and Fantastico installers work and install Drupal 7. But if you need the older version of Drupal, you do have to install manually.

[genxspirit40]

thanks but the issue get solved. i uses softaculous, it installs same version 6.20 which is required by me.