Need help?

Our experts have had an average response time of 13.14 minutes in February 2024 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

Database creation error: access denied odoo – Quick fix!

by | Dec 8, 2019

Receiving “Database creation error: access denied” while creating a database in Odoo? We can help you fix it.

Odoo is a platform that companies can use to easily manage the basics of the company such as human resources, finance, accounting, sales, and many other enterprise features.

At Bobcares, we often receive requests to solve such database creation errors as a part of our Server Management Services.

Today, we’ll discuss the error in detail and see how our Support Engineers fix it.

 

What causes database creation error: access denied odoo?

The error happens when the master password is not the same as the admin password in odoo configuration file.

That means the Master Password entered in the Create Database step doesn’t match the admin_password in the odoo-server.conf file

A typical error message appears as:

database creation error: access denied odoo

How we fix database creation: error access denied odoo?

We saw what causes this error to occur. Let’s now see how our Support Engineers fix this error for our customers.

Recently, one of our customers approached us with the same error.

Our Support Engineers started troubleshooting the problem by checking if the admin_password in odoo.conf is correct. We saw the admin_password was displaying something like this,

admin_password = $pbkdf2-sha512$25000$15oTopRSSomREkLIeQ8hRA$QlTTxd4bqTTxSI0/u4g/yukO9jT2yFtTx4sAu46GtMKHnooPWT

So we won’t be able to know what is the DB-admin password.

But we can change it. So we changed it as below.

admin_passwd = 'new-password'

Then we restarted the odoo server using the command,

service odoo restart

And then we tried to recreate the DB again. This also didn’t work. So we checked for the parameters db_user and db_password in the odoo configuration file which is placed in /etc/odoo/odoo.conf.

The customer was using PostgreSQL with the specified user and password.

So we specified the same user and password in /etc/odoo/odoo.conf in parameters db_user and db_password.

Then we restarted the PostgreSQL using the command

/etc/init.d/postgresql restart

Finally, this fixed the error.

 

[Need any assistance in fixing database errors? – We’ll help you]

 

Conclusion

In short, the error occurs when the master password set in Odoo conf file is not the same as the database password. Today we saw how our Support Engineers fix this error.

18 Comments

  1. fernando fernandez montoya

    i have the same problem in windows some help please

    Reply
    • Maheen Aboobakkar

      We’ll be happy to talk to you on chat to resolve the issue (click on the icon at right-bottom).

      Reply
      • Carmen

        Buenas noches no puedo crear una base de datos en Odoo esto ocurrió después de borrar una de las bases de datos que tenía creada, lo raro es que entro en etc/Odoo/configuración y tengo los mismo parametros que siempre he tenido no se que pasó

        Reply
        • Hiba Razak

          Hello Carmen,
          Our experts can help you with the issue.we will be happy to talk to you through our live chat(click on the icon at right-bottom).

          Reply
    • Biniyam Shimeles

      can you please help me on database creation error on windows

      Reply
      • Hiba Razak

        Hi,
        Please contact our support team via live chat(click on the icon at right-bottom).

        Reply
  2. josue

    muchas gracias por la información, no era mi problema pero me ayudaste a corregir el que tenía

    Reply
    • Hiba Razak

      Thank you

      Reply
  3. *prudhvi raj vedurparthi

    i have same problem from one week please hep me as soon as possible

    Reply
    • Maheen Aboobakkar

      Hello,

      We’ll be happy to talk to you on chat (click on the icon at right-bottom).

      Reply
  4. lost

    hey guys I am trying to get into odoo for thefirst time but it doesn’t want to.
    when I enter my info and click on start it just takes me back to the home page.

    Reply
    • Hiba Razak

      Hi,
      Please contact our support team via live chat(click on the icon at right-bottom)

      Reply
  5. basta

    I have same problem, can you please help me

    Reply
    • Hiba Razak

      Hi,
      Please contact our support through live chat(click on the icon at right-bottom).

      Reply
  6. Okurut Jonathan

    Database creation error on wimdows

    Reply
    • Hiba Razak

      Hi,
      Please contact our support team through live chat (click on the icon at right-bottom).

      Reply
  7. Safaa Habbas

    I have the same problem, can someone help me?

    Reply
    • Hiba Razak

      Hi,
      Our experts can help you with the issue.we will be happy to talk to you through our live chat(click on the icon at right-bottom).

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Categories

Tags

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF