# Trying to configure Passbolt , database configuration **URL:** \ **Category:** Installation Issues\ **Created:** [May 5, 2022, 7:13am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322 "2022-05-05T07:13:28Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![cedric1](https://avatars.discourse-cdn.com/v4/letter/c/8e8cbc/32.png) [@cedric1](https://community.passbolt.com/u/cedric1)\ **Post date:** [May 5, 2022, 7:13am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322/1 "2022-05-05T07:13:28Z")
hi , I just installed passbolt on debian 11 for testing, everything is going as it should. when I go to the configuration page at the maria db connection step impossible ![image](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/2X/3/35f5c30036c448811d521be9d9564ac1a0991d57.png) in the logs May 5 09:11:01 passbolt-test mariadbd[35338]: 2022-05-05 9:11:01 1022 [Warning] Access denied for user ‘’@‘localhost’ in the log the user is not visible ‘’@‘localhost’ on the server connection to the base with the user and password ok. Impossible from the outside, test from another server idem. do you have an idea? ---
**Author:** ![AnatomicJC](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/anatomicjc/32/962_2.png) [@AnatomicJC](https://community.passbolt.com/u/AnatomicJC)\ **Post date:** [May 5, 2022, 7:35am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322/2 "2022-05-05T07:35:17Z")
Hi @cedric1 and welcome to passbolt community forum. Is your database located on the same server than passbolt ? If yes, can you confirm you can connect to database with this command (you will be prompted for your password): ```auto mysql -u passboltadmin -p passboltdb -h 127.0.0.1 ``` I see you have hidden your database host server address in your screenshot: ![image](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/2X/c/cc860932d87587e9bd6bd999d4b8b7fb5f6abeb1.png) By default, with mysql on the same server than passbolt, you cannot connect with your server IP or hostname, you must use localhost or 127.0.0.1. If you are using a hostname or an ip like 192.168.1.50, you must try to connect with this hostname or IP, aka: ```auto mysql -u passboltadmin -p passboltdb -h 192.168.1.50 ``` Best, ---
**Author:** ![cedric1](https://avatars.discourse-cdn.com/v4/letter/c/8e8cbc/32.png) [@cedric1](https://community.passbolt.com/u/cedric1)\ **Post date:** [May 5, 2022, 7:50am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322/3 "2022-05-05T07:50:18Z")
> [@AnatomicJC](#): > > `mysql -u passboltadmin -p passboltdb -h 192.168.1.50` Hi \_jc , thx for your help , yes my database is on the same server. if I enter 127.0.0.1 in the interface it works. I did not think that to inform its ip of the network and not the loopback would pose problem. on the serveur it is ok but with other server connection refused [cbarrere.pcp-cbarrere] ➤ mysql -u passboltadmin -p passboltdb -h 10.1.252.9 Enter password: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘10.1.252.9’ (111 “Connection refused”) thx for your help , I will continue to finish the configuration and do my validation tests in relation to our needs. ---
**Author:** ![cedric1](https://avatars.discourse-cdn.com/v4/letter/c/8e8cbc/32.png) [@cedric1](https://community.passbolt.com/u/cedric1)\ **Post date:** [May 5, 2022, 7:51am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322/4 "2022-05-05T07:51:14Z")
mysql -u passboltadmin -p passboltdb -h 110.1.252.9 don’t work [cbarrere.pcp-cbarrere] ➤ mysql -u passboltadmin -p passboltdb -h 10.1.252.9 Enter password: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘10.1.252.9’ (111 “Connection refused”) ---
**Author:** ![AnatomicJC](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/anatomicjc/32/962_2.png) [@AnatomicJC](https://community.passbolt.com/u/AnatomicJC)\ **Post date:** [May 5, 2022, 8:09am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322/5 "2022-05-05T08:09:55Z")
Hi, By default, mysql connection is restricted to localhost, you can check this by connecting to the mysql database and execute this request: ```auto MariaDB [mysql]> SELECT host, User FROM user; +-----------+-------------+ | Host | User | +-----------+-------------+ | localhost | mariadb.sys | | localhost | mysql | | localhost | passbolt | | localhost | root | +-----------+-------------+ 4 rows in set (0.001 sec) ``` If passbolt is on the same server, there is no reason to allow mysql connection to the IP address of your server. If you want do do this, you will have to execute a request like this one: ```auto CREATE USER 'your-user'@'your-ip' IDENTIFIED BY 'your-password'; ``` Cheers, ---
**Author:** ![cedric1](https://avatars.discourse-cdn.com/v4/letter/c/8e8cbc/32.png) [@cedric1](https://community.passbolt.com/u/cedric1)\ **Post date:** [May 5, 2022, 9:29am UTC](https://community.passbolt.com/t/trying-to-configure-passbolt-database-configuration/5322/6 "2022-05-05T09:29:34Z")
> [@AnatomicJC](#): > > you can check this by connecting to the mysql database and execute this request: thx for information , you right it is not good to allow mysql connection from other server