Database Creation & Management

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

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

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 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

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

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

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

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

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 change your Joomla password via the database

If you lose access to your Joomla administrator dashboard, you can reset your password using the built-in recovery link on the login screen. This sends...

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