Database creation error: access denied odoo – Quick fix!

by Anjaly Baby | 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.

20 Comments

fernando fernandez montoya on 2021-10-10 at 05:55

i have the same problem in windows some help please
Reply
- Maheen Aboobakkar on 2022-07-14 at 10:00
  
  We’ll be happy to talk to you on chat to resolve the issue (click on the icon at right-bottom).
  Reply
  - Carmen on 2024-02-09 at 04:55
    
    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 on 2024-02-09 at 15:48
      
      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 on 2022-11-12 at 22:02
  
  can you please help me on database creation error on windows
  Reply
  - Hiba Razak on 2022-11-16 at 09:05
    
    Hi,
    Please contact our support team via live chat(click on the icon at right-bottom).
    Reply
josue on 2022-05-21 at 20:11

muchas gracias por la información, no era mi problema pero me ayudaste a corregir el que tenía
Reply
- Hiba Razak on 2022-06-23 at 09:30
  
  Thank you
  Reply
*prudhvi raj vedurparthi on 2022-07-19 at 15:18

i have same problem from one week please hep me as soon as possible
Reply
- Maheen Aboobakkar on 2022-07-19 at 20:28
  
  Hello,
  
  We’ll be happy to talk to you on chat (click on the icon at right-bottom).
  Reply
lost on 2022-07-22 at 01:26

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 on 2022-07-22 at 09:23
  
  Hi,
  Please contact our support team via live chat(click on the icon at right-bottom)
  Reply
basta on 2023-02-07 at 14:23

I have same problem, can you please help me
Reply
- Hiba Razak on 2023-02-07 at 14:30
  
  Hi,
  Please contact our support through live chat(click on the icon at right-bottom).
  Reply
Okurut Jonathan on 2023-03-04 at 03:06

Database creation error on wimdows
Reply
- Hiba Razak on 2023-03-09 at 15:10
  
  Hi,
  Please contact our support team through live chat (click on the icon at right-bottom).
  Reply
  - Joseph yusto on 2024-03-17 at 16:37
    
    I have the same problem, can someone help me?
    
    on Database creation error on wimdow.
    plz i ask your help
    Reply
    - Hiba Razak on 2024-05-13 at 15:54
      
      Hello,
      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
Safaa Habbas on 2023-09-19 at 00:28

I have the same problem, can someone help me?
Reply
- Hiba Razak on 2023-09-20 at 17:01
  
  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