Databases

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

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

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

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

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

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

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

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