Database management in the Panel
How to connect to a database with MySQL Workbench
Below we explain step by step how to establish a connection to your MySQL database using MySQL Workbench, including the necessary screenshots to guide you during the process. 1. Download and installation of MySQL Workbench MySQL Workbench is a free ...
Pilotron | Database management in cdmon
Pilotron is your artificial intelligence assistant in the cdmon control panel. With this tool, you can manage and obtain information about your databases quickly and easily, without needing to manually navigate through the control panel. In this ...
Update of MariaDB cdmon
At cdmon we are updating the MariaDB version on our servers, upgrading to version 10.11. This update improves database performance and security, but it also introduces some changes that may affect certain applications or queries. The update will be ...
How to import a database by SSH
Before starting, it is important to mention that not all hosting plans provide SSH access. To follow this guide, you will need a plan that includes this feature. The available plans are the Senior plans or higher. You can check our comparison table ...
How to create MySQL databases
The use of dynamic pages or content management systems requires the use of MySQL databases. These databases can be created from the cdmon control panel. To create a database, first access the hosting management section. Once you access the hosting ...
How to import CSV files to MySQL from PHP and SSH
cdmon ensures the security and proper operation of its services. For this reason, certain insecure MySQL functionalities for loading local files in bulk are not available. Below we explain three methods to import data into MySQL. 1.-Import a CSV file ...
How to delete a database
In some cases it is necessary to delete the database that we have in the hosting in order to create a new one, or because the contracted plan only allows a maximum of 1 and we need to remove the current one. In this guide we will show how to delete ...
How to connect to MySQL via SSH
Any hosting that has SSH access enabled can connect to MySQL via console. To do so, you must use the following command: mysql -h ipweb -u databaseuser -p -h: In this option, enter the web IP of the hosting. You can check the IP in the Server ...
How to connect to an external BBDDD MS SQL
If you want to connect from your web hosting to an external MS SQL database, you can use the mssql_connect() function. Below we show an example code to use a connection with mssql_connect. //replace the values with those of your server. $myServer = ...
How to import MySQL databases from Control Panel
In the cdmon Control Panel you can execute SQL scripts that allow you to import MySQL data into databases directly on the MySQL server. You can find the tool in the hosting Control Panel. To execute a MySQL script, first upload it via FTP to the ...
Where to view MySQL connection data
Many of the applications that you can install on your website require databases and, in order to connect to them and use them, you need the MySQL connection details. You can find this information in the hosting management panel. Within the hosting ...
How to free up space from a database
A database is a tool used to collect and organize information. Databases can store information about people, products, orders, or other items. cdmon databases are MySQL. MySQL is based on a client-server model. The core of MySQL is the MySQL server, ...
How to change the MySQL user password
To change the password for database access, we must go to the hosting where the database is installed. Next, go to the "Databases" column and access "MySQL Users" Once inside, go to the "MySQL database connection details" section and click on "Change ...
ConnectiLogs | MariaDB user management of cdmon hostings
The ConnectiLogs tool is designed to provide clear and simple access to the logs of the hostings you have created in your control panel. From this section, you can view and analyze server logs through an intuitive panel, accessible to both beginners ...