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…
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…
Virrage ImagesshutterstockAre you familiar with the File Transfer Protocol, better known as FTP? If not, it’s worth exploring, as this protocol makes digital file transfers much easier. It’s especially useful when working with large volumes of data, where an FTP server is often the most efficient…
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 Authorisation 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 unauthorised 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…
Titima OngkantongShutterstockMariaDB vs SQLite is a frequent comparison in the open-source database world. MariaDB is a powerful client-server system, while SQLite is a lightweight library that runs inside applications. Knowing the strengths and limits of MariaDB and SQLite helps developers and businesses…