Access denied for user 'username'@'localhost' to database 'dbname' [1044]

[xboy]

i have just created db and username. i getting this error when i am trying connect it.

i set dbhost as localhost and used my username and password which i had manuelly created. what can be wrong?

 

[cwilkinson199878]

Have you created the database through softaculous or the cpanel first?

 

[xboy]

yes i did. created a database under localhost and added username for it.

in config.php
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'dijitalf_forum';    'db i created in cpanel
$dbuser = '*******';         'username i created for db in same way
$dbpasswd = '*******';    'password
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';


@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

---------- Post added at 02:18 PM ---------- Previous post was at 02:16 PM ----------

i have import sql file to my db? something can be wrong with version of php? but i dont thinks so

 

[descalzo]

Remember that the username you created is of the format dijitalf_igor , not just igor

Did you add the user to the database with the ALL PRIVILEGES box checked?

 

[xboy]

no i didnt i created username like "db_myname" but i dont remember i checked "ALL PRIVELEGES" box.

 

[descalzo]

cPanel --> MySQL Databases

Current Databases -- remove the user from the database (do not delete the user)
Add User To Database -- add user back onto database, make sure to check the ALL PRIVILEGES

 

[xboy]

i solved it. thank you for your help. i forgot clicking "add" and set privileges"