Guides and Tutorials / Database

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. Connect (...)

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 In the MANAGE W (...)

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: Then we go to Service Management and Database Management, (...)

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 mo (...)

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 m (...)

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. Environme (...)

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 powe (...)

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 (...)

How to open port 3306 in Plesk

In order to perform a complete migration from another Hosting to SWHosting, it is essential that port 3306, which corresponds to the MySQL database, is open. In the following manual, we will show you how to open port 3306 in Plesk. 1. Once logged in (...)

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 (...)

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 t (...)

Error to establish a connection to the database in WordPress

When you consult your web page, the hosted code usually makes a connection to the database (hereinafter DB) to know what content should be displayed. This happens with dynamic pages (e.g. PHP), that is, the content is not always the same. Pages whose (...)

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 (...)
i