...

Databases & MySQL

Database Performance & Troubleshooting

Database Performance & Troubleshooting collects articles on this topic. Add a clear description so visitors and search engines understand what belongs here.

Database Basics & Concepts

Database Basics & Concepts - dedicated category for this topic. Content here focuses on this subject rather than neighboring categories.

Access to the database via phpMyAdmin

phpMyAdmin is a powerful, web-based tool provided by mybox that allows you to manage your MySQL databases without writing complex code. It provides a visual...

Written by mbadmin
2025-12-28

Add a new CRON job

A CRON job is a time-based task scheduler that allows you to automate repetitive actions on your server, such as backing up databases, sending scheduled...

Written by mbadmin
2025-12-28

Create a new database

In order to create a new database, select the Databases option in the mybox panel, then MySQL Databases and click +Add. From the list, select...

Written by mbadmin
2025-12-17

Create a new database user

To add a new user, open the Databases module in the the mybox panel, then MySQL Users and click +Add. You will be able to...

Written by mbadmin
2025-12-17

Creating a database and a database user

A MySQL database is a secure environment used to store your website’s structured data, such as posts, user profiles, and settings. To function, a database...

Written by mbadmin
2025-12-17

Creating your own MySQL backup

mybox creates automatic daily backups of all databases on your account. In addition, you can create a manual backup at any time - for example,...

Written by mbadmin
2025-12-28

How can I add a user who will have access to all MySQL databases?

In some situations, particularly when managing multiple websites or transferring data between databases, it may be useful to have a single MySQL user with access...

Written by mbadmin
2025-12-17

How do I change a user assigned to a database?

Changing the user assigned to a MySQL database is a two-step process: you must first grant access to a new user and then revoke access...

Written by mbadmin
2025-12-17

How do I change my WordPress password through the database?

By default, WordPress allows password reset through the login page using the “Forgot password” option. A reset link is sent to the email address associated...

Written by mbadmin
2025-12-28

How do I change MySQL database user permissions?

From the the mybox panel level, you can manage databases, but also users who are associated with a specific database. Each user is granted read...

Written by mbadmin
2025-12-17

How do I download database copies via the mybox panel?

The mybox Panel automatically creates database backups, allowing you to download and restore previous versions of your MySQL databases when needed. This can be useful...

Written by mbadmin
2025-12-18

How to manage and clean the database with a plugin for CMS WordPress?

If the database of your website in “WordPress” has grown significantly for no specific reason, i.e. new publications or products have not been added to...

Written by mbadmin
2025-12-19

How to manage databases in the mybox panel?

If you want to see a list of all the databases you have created, select Databases in the the mybox panel, and then MySQL Databases....

Written by mbadmin
2025-12-19

How to restore/upload a database from a .sql or .sql.gz file via phpMyAdmin?

If you have a database backup in .sql or .sql.gz format, you can import it using phpMyAdmin. Before you begin, make sure you have: If...

Written by mbadmin
2025-12-26

How to restore a database from a .sql file?

Using the instructions below, you can import a much larger database than using standard means such as phpMyAdmin. 1. To restore a copy of a...

Written by mbadmin
2025-12-27

Obtaining the login and password to the database from the wp-config.php file

WordPress uses a configuration file called wp-config.php to store database connection details. These include the database name, username, password, and host. If you do not...

Written by mbadmin
2025-12-23

MySQL database optimization and repair

If you suspect that your website’s database tables are fragmented, inefficient, or damaged, you can use the optimization and repair tools available in phpMyAdmin. Optimizing...

Written by mbadmin
2025-12-19

Restoring a MySQL database from backup

mybox creates automatic daily backups of all databases on your account. If you need to roll back a database to an earlier state - for...

Written by mbadmin
2025-12-19

Manage database users

To view all users currently able to use databases, select Databases in the the mybox panel, and then MySQL Users. After performing this operation, you...

Written by mbadmin
2025-12-19

Sample MySQL commands

MySQL is a popular database management system that is widely used to store and manage data in various applications and websites. In this article, we’ll...

Written by mbadmin
2025-12-19

What are databases?

A database is a set of data stored in a strictly defined way in structures corresponding to the assumed data model. In common terms, it...

Written by mbadmin
2025-12-19

What Is MySQL?

MySQL is one of the world’s most popular relational database management systems (RDBMS). It is used to store, organize, and manage data for websites, web...

Written by mbadmin
2025-12-22

What to do when WordPress shows a database connection error?

In a situation where “WordPress” does not have the ability to properly communicate with the database, instead of your website, you may receive a message...

Written by mbadmin
2025-12-28

What to do when WordPress displays the message “Database Update Required”?

After updating WordPress to a newer version, you may encounter a situation where attempting to access the administration panel (wp-admin) results in a message stating:...

Written by mbadmin
2025-12-22

Why is the size of the SQL database different after exporting to a file than on the server?

When administering a website or application on mybox, downloading a database backup often reveals a confusing technical quirk: the downloaded .sql file is significantly smaller...

Written by mbadmin
2025-12-22

What is a MySQL archive backup?

A MySQL archive backup is an additional, non-guaranteed copy of your database that is stored outside of your plan’s standard backup retention period. These backups...

Written by mbadmin
2026-03-27

How to fix the “Error Establishing a Database Connection” in WordPress

When your WordPress site displays this error, it means the PHP code is unable to link up with the MySQL database where your posts, pages,...

Written by mbadmin
2026-04-08

Qdrant: The High-Performance Vector Database

Qdrant (pronounced “quadrant”) is a vector similarity search engine and database built in Rust for maximum performance and memory safety. As AI applications move from...

Written by mbadmin
2026-04-14

Index WP MySQL For Speed: Accelerating WordPress Database Performance

In 2026, database efficiency is the “hidden” key to passing Core Web Vitals. While most optimization focuses on images and CSS, the database is often...

Written by mbadmin
2026-04-15

How to check and end processes in MySQL

Managing active database connections is essential for maintaining the performance of your mybox environment. If a website slows down or becomes unresponsive, a “stuck” or...

Written by mbadmin
2026-04-23

Optimizing Your WordPress Database with Advanced Database Cleaner

A clean database is a mechanical necessity for a high-performing mybox-hosted website. Over time, your WordPress database accumulates “digital clutter”-old post revisions, trashed comments, orphaned...

Written by mbadmin
2026-05-10

Comparing MySQL InnoDB and MyISAM Storage Engines

MySQL supports multiple storage engines, each designed for different use cases and performance requirements. The two best-known storage engines are InnoDB and MyISAM. While both...

Written by mbadmin
2026-05-25

Better Search Replace: How to Safely Modify Your WordPress Database

Making changes directly to a WordPress database can be risky, especially when updating URLs, replacing text across multiple pages, or migrating a website to a...

Written by mbadmin
2026-05-28

Do I Need a Database for My Website?

Not every website requires a database. Whether you need one depends entirely on how your website is built and what functionality it provides. A database...

Written by mbadmin
2026-05-28

How SQL Injection (SQLi) Attacks Work

SQL Injection (SQLi) is one of the most common web application vulnerabilities. It occurs when an application improperly handles user input and allows malicious SQL...

Written by mbadmin
2026-05-29

What is the host for MySQL connections at mybox?

Due to the fact that databases are running on a separate infrastructure to ensure higher performance, specifying “localhost” during manual installation or configuration of the scripts you...

Written by mbadmin
2026-05-31

How to change the encoding of a MySQL database?

The character encoding of a MySQL database determines how text data is stored and interpreted. Using the correct encoding is important for proper display of...

Written by mbadmin
2026-06-01

Changing the password to the PrestaShop backend using the traditional method and via the database

If you have lost the password for your PrestaShop store panel, you can recover it in two ways. Basic method If you have access to...

Written by mbadmin
2026-06-02

Repairing and Optimizing the Database in WordPress

WordPress includes a built-in database repair and optimization tool that can be enabled manually. This is useful when database tables may be corrupted, inefficient, or...

Written by mbadmin
2026-06-02

What Are the Advantages and Disadvantages of Relational Databases?

Relational databases store data in tables consisting of rows and columns, with relationships established between different tables. They are among the most widely used database...

Written by mbadmin
2026-06-02

What Is the Structure of the Relational Database Model?

The relational database model was introduced in 1970 by Edgar F. Codd. In his groundbreaking paper, he proposed organizing data into tables consisting of rows...

Written by mbadmin
2026-06-02

How Does a Relational Database Work?

A relational database stores data in tables that contain rows and columns. This structure makes it easy to organize, search, and manage related information. Each...

Written by mbadmin
2026-06-02

What Is a Relational Database?

A relational database is a type of database that organizes data into tables consisting of rows and columns. Relationships between different tables are defined using...

Written by mbadmin
2026-06-02

Types of Databases

Databases come in several different types, each designed for specific use cases, data structures, and performance requirements. They range from simple file-based systems to highly...

Written by mbadmin
2026-06-02

How to Add a WordPress Administrator Through the Database

If you cannot access the WordPress administration panel, you can create a new administrator account directly in the website’s database. This method can be useful...

Written by mbadmin
2026-06-03

How to Find Database Login Credentials in Joomla’s configuration.php File

Sometimes you may need to access your Joomla database through phpMyAdmin, for example to modify settings, restore data, or troubleshoot issues. If you do not...

Written by mbadmin
2026-06-03

How to Allow an External IP Address to Connect to a MySQL Database

If you need to connect to your MySQL database from an external location, such as: you must first authorize the external IP address that will...

Written by mbadmin
2026-06-03

WordPress Optimization – Removing Transients

While WordPress is running, it stores temporary information in the database known as transients. These records are used by WordPress core, themes, and plugins to...

Written by mbadmin
2026-06-07

WordPress Optimization – Removing Revisions

WordPress automatically creates revisions whenever you edit posts, pages, or other content. These revisions act as restore points, allowing you to compare changes and revert...

Written by mbadmin
2026-06-07

WordPress Optimization – Removing Metadata from Deleted Posts

WordPress stores additional information related to posts, pages, and custom content types in a separate database table called wp_postmeta. This table contains metadata used by:...

Written by mbadmin
2026-06-07

WordPress Optimization – Removing Leftover Data from Deleted Plugins

One of WordPress’s greatest strengths is its extensive plugin ecosystem. Plugins allow you to add new features and functionality without writing custom code. However, not...

Written by mbadmin
2026-06-07

WordPress Optimization – Removing Leftover Data from Deleted Plugins

One of WordPress’s greatest strengths is its extensive plugin ecosystem. Plugins allow you to add new features and functionality without modifying the core system. During...

Written by mbadmin
2026-06-07

How to Set a Custom Database Connection Error Page in WordPress

By default, when WordPress cannot establish a connection to the database, visitors see a generic error message similar to: You can replace this default message...

Written by mbadmin
2026-06-07