Guides and Tutorials / Database

How to create a MySQL or MariaDB database

A database is a set of data belonging to the same context and systematically stored for later use. Any website that contains data that can be consulted through a search tool on the website itself or that allows data to be entered through a text form need (...)

Error to establish a connection to the database in WordPress

Cuando visitas una página web dinámica (por ejemplo, desarrollada en PHP), el sistema suele conectarse a una base de datos (BBDD) para obtener la información que debe mostrar en pantalla. A diferencia de las páginas estáticas (como las creadas únicamente e (...)

How to access phpMyAdmin from SWPanel

What is phpMyAdmin? PHPMyAdmin is a database manager. It is a tool used to manage (create, modify, delete...) any record of your databases through a web interface. How to access phpMyAdmin? You can access phpMyAdmin from your SWPanel, you just need to know (...)

How to import and export databases with phpMyAdmin

Importing the database with phpMyAdmin To import your web database to your new hosting in SWPanel you will have to follow the following steps: 1. First of all, you must access your SWPanel and in the top search window indicate the name of the hosting servi (...)

How to open port 3306 in Plesk

Para realizar una migración completa desde otro proveedor de Hosting hacia SW Hosting, es imprescindible que el puerto 3306 —utilizado por las bases de datos MySQL— esté abierto. Este manual detalla los pasos necesarios para habilitar el puerto 3306 en Ple (...)

How to open 3306 port in cPanel

In order to carry out a complete migration from another Hosting to SW Hosting, it is essential that port 3306, which corresponds to MySQL (database), is open. In the following manual, it will be shown how to open port 3306 in cPanel and allow access to SWH (...)

How to Import a SQL file into my Database in SWPanel with HeidiSQL

With SWPanel you can use the phpMyAdmin tool to access the management of your databases, such as exporting or importing them. Also, you can use any kind of MySQL/MariaDB database management application, such as HeidiSQL, which allows a much more powerful d (...)

How to delete a MySQL or MariaDB Database

To delete a MySQL or MariaDB database from SWPanel, you will have to follow the following steps: Access the dashboard of the hosting service where the database is created. You can use the top search engine of your SWPanel info_capture The screenshot (...)

How to import a database via SSH

In this manual we will show you how to import a database(MySQL) into your Cloud server using SSH, for example a Cloud SWPanel Smart Web D5. This is useful if the import via phpMyAdmin fails or any other issue when uploading the database. 1. Environment pre (...)

How to Import a SQL file to my Database in SWPanel with DBeaver

With SWPanel you can use the phpMyAdmin tool to access the management of your databases, such as exporting or importing them. Also, you can use any kind of database management application, such as DBeaver, which allows a much more powerful database managem (...)

How to Import or Export a Database in SWPanel with MySQL Workbench

With SWPanel you can use the phpMyAdmin tool to access the management of your databases, such as exporting or importing them. Also, you can use any kind of MySQL/MariaDB database management application, such as MySQL Workbench, which allows a much more pow (...)

How to Create a Database User from SWPane

Create a new DB user To create a new database access user you can do it following these instructions: First, we access the dashboard of the service where we want to create the database user: info_capture The screenshot is for guidance only. It was taken (...)

How to change the password of your WordPress linked database user

To change the password of your database user linked to WordPress, you will need to follow the steps below: Access the dashboard of the hosting service where the database user is. You can use the top search engine of your SWPanel info_capture The scre (...)

Basic MySQL queries

MySQL is a widely used relational database management system that allows you to store and retrieve data efficiently. Here are the basic MySQL queries so that you can interact with your database using, as an example, a database with employees. Connecting to (...)
i
Email send icon