...

MySQL & MariaDB

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

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

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

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

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

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

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