"[message] => DB Error: no such table" error after installing civicrm

Question

I installed CiviCRM 5.47.3 plugin using composer in the centos 8 server.

my drupal version is 9.3.5

After installing CiviCRM on the server CiviCRM plugin is enabled automatically in admin extension section

But after configuring CiviCRM no page is loading and facing the below error,

Initialization Error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
FROM civicrm_setting
WHERE (domain_id = 1) AND (is_domain = 1)
 [nativecode=1146 ** Table 'civicrm_cidd.civicrm_setting' doesn't exist]"]
)

I installed CiviCRM by referring the below doc https://docs.civicrm.org/installation/en/latest/drupal8/

PHP version is v8.0.27

any guide is appreciated if need any more details please comment

Answer 1

Verify that your database credentials in your CiviCRM settings file web/sites/default/civicrm.settings.php is correct.

If you are using a separate CiviCRM database (i.e., not using the same database as drupal), you need to specify separate SQL credentials.

By default, CiviCRM uses the installed (Drupals) MySQL credentials. Have you verified that you took the following under consideration? https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-connection

Verify the MySQL user has super privileges. You should NOT be using root in SQL, but instead should have a separate user account.

GRANT SUPER ON *.* TO 'civicrm_user'@'localhost';

Another thing to check: Make sure your DB password does NOT have any special characters in it. I ran into a similar error with special characters in my DB password, which prevents Civi from connecting to MySQL (Even tho Drupal could).