GUIDE DATABASE CONNECTION DATA, WHERE TO FIND THEM? 2020 -WAU

Home/Posts/Administración del Hosting/GUIDE DATABASE CONNECTION DATA, WHERE TO FIND THEM? 2020 -WAU

Databases where to find the connection data?

Don’t be fooled by the title, this is a recurring question, mainly in Support Departments, where clients of all kinds and with different levels of knowledge ask themselves the same question over and over again Where do i find the connection data from the database?.

It has nothing to do with what you know or don’t know, if you have spent a lot of time using one CMS and suddenly switch to another, you may find yourself a bit lost at first, mainly in the process of installing or moving a website, which among other details, needs the database connection data to work.

I have already explained in other articles how to locate the Database Host, or how to create, restore or import a database, so now it is time for you to know where to locate data from an existing database, already configured in some dynamic content manager (CMS) so you can write them down and later make use of them.

This data is very useful when you have to copy or clone a website in production to another folder for testing or to another server to move it (although there are other procedures for this).

Locate the data from the database in different CMS

In WordPress:

In the File wp.config.php Localizable in the main folder of the WordPress installation (or in the folder of the affected installation, if you have multiple installations).

define('DB_NAME', 'pruebasw_pt13'); // Nombre de la base de datos define('DB_USER', 'pruebasw_pt13'); // Usuario de la base de datos define('DB_PASSWORD', 'A)5~u[#kdZ08([0'); // Contraseña de la base de datos define('DB_HOST', 'localhost'); // Host de la base de datos
Database data in WordPress

In PrestaShop:

In the File settings.inc.php Located in the / public_html / config folder of the PrestaShop installation, or in the folder of the affected installation, if you have several installations).

define('_DB_NAME_', 'pruebasw_ph8'); // Nombre de la base de datos define('_DB_USER_', 'pruebasw_ph8'); // Usuario de la base de datos define('_DB_PASSWD_', 'R([email protected]@3'); // Contraseña de la base de datos define('_DB_SERVER_', 'localhost'); // Host de la base de datos
Database data in PrestaShop

In Joomla:

In the File configuration.php Located in the main folder of the Joomla installation and that you can usually find with 444 permissions, so if you are going to edit it make sure to put 644 permissions first.

public $db = 'praiador_pjw6'; // Nombre de la base de datos public $user = 'praiador_pjw6'; // Usuario de la base de datos public $password = 'G*[email protected]^[3'; // Contraseña de la base de datos public $host = 'localhost'; // Host de la base de datos
Database data in Joomla

In Moodle:

In the File config.php Located in the main folder of the Moodle installation.

$CFG->dbname = 'pruebasw_mood2';  // Nombre de la base de datos $CFG->dbuser = 'pruebasw_mood2';  // Usuario de la base de datos $CFG->dbpass = 'U]#[email protected](h55.#3'; // Contraseña de la base de datos $CFG->dbhost = 'localhost';  // Host de la base de datos
Database data in Moodle

For other CMS you will have to see in which folder these usual parameters are configured for the management and connection of the database, or consult your Support Department to provide you with this information.

Other articles that may interest you:

Member of the Websites Are Us technical team.
Coordinator of content on the Blog and YouTube.
Technical support in CyberProtector. Teacher at Websites Are Us Learning.

By |2020-05-12T01:09:48+00:00May 12th, 2020|Administración del Hosting|