sakkmesterkeshutterstockMariaDB offers two methods for selecting a database within its management system. In this dedicated article, we illustrate how to use the USE statement in the command line and the mysqli_select_db function in PHP with a straightforward example, and also highlight what you need to…
Titima OngkantongShutterstockThe system variable MariaDB max_allowed_packet determines the maximum size a single data packet can be during communication between client and server. If the value is too low, larger data imports or SQL queries will fail with error messages. This parameter can be specifically…
Converting the MySQL extension to MySQLi led to some uncertainty in the PHP community since some of the industry’s heavyweights like WordPress continued to rely on the old extension despite it being deprecated. However, as of PHP 7, this extension is no longer available. In this…
ipopbaShutterstockThe term vendor lock-in has traditionally been used in connection with the use of proprietary software. But vendor lock-in also plays a crucial role in the age of the cloud. How exactly does vendor lock-in happen and what measures can a company take to protect itself? Read on to…
PoparticShutterstockAt some point, you’ll undoubtedly have been prompted to “clear your cache.” But what exactly does it mean? What does this intermediate storage do, and why should it be cleared at all? Read this article to find out how a cache works, what tasks it performs, and much more on the…
Virrage ImagesshutterstockAre you familiar with the File Transfer Protocol, or FTP for short? If not, you should get to know it, as this transfer protocol greatly simplifies digital data exchange. Especially when dealing with large amounts of data, using an FTP server is highly recommended. To upload…
Ahmet MisirligulshutterstockMySQL and MariaDB are powerful, widely used relational database systems designed for efficiently storing and managing structured data. This comprehensive step-by-step guide explains how to install MySQL and how to install MariaDB on various Linux distributions, showing you how to…
123dartistShutterstockThe Auth Code (short for Authorization Code) or AuthInfo Code is required when you want to move your domain to a different provider. By requesting the code, the new provider ensures that you are the registered user of the domain and helps protect it from unauthorized or…
AI-generatedSay goodbye to dedicated server hosting. The future belongs to the cloud. Still not sure if you should make the switch to flexible cloud hosting though? Take a look at four arguments that illustrate why a contemporary web hosting strategy should provide resources via the internet…
REDPIXEL.PLshutterstockForgetting the root password in MySQL or MariaDB doesn’t need to become a serious issue. By following the right steps, you can reset a MySQL/MariaDB root password quickly and easily at any time. This dedicated guide walks you step by step through both methods and points out what…