MySQL

Image: Magentogpointstu­dioShut­ter­stock

Magento

Many con­tem­po­rary content man­age­ment systems such as WordPress and TYPO3 can be used to design and program web stores with the help of plugins. But depending on the CMS, plugins can be pretty in­con­ve­nient to manage, making them a poor choice for larger projects. Some content…

  • SEO
  • Magento
  • Online Store
  • E-Commerce
  • MySQL
Read more
Image: Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML FormGoro­denkoffshut­ter­stock

Use PHP to Insert In­for­ma­tion Into a MySQL/MariaDB Database From an HTML Form

A PHP script is a con­ve­nient way to accept in­for­ma­tion submitted from a website's HTML form and insert it into a MySQL/MariaDB database. This tutorial will cover how to create a basic PHP script for inserting data, and an HTML form to take user input from a webpage and pass it to…

  • Database
  • PHP
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: Is papaya CMS the right content management system for your project?Gustavo FrazaoShut­ter­stock

Is papaya CMS the right content man­age­ment system for your project?

The de­vel­op­ers advertise papaya as a CMS designed for high-per­for­mance content man­age­ment, and this claim is backed by its powerful features and robust ca­pa­bil­i­ties. However, does this imply that papaya CMS is only suitable for ex­pe­ri­enced ad­min­is­tra­tors and web­mas­ters? And what…

  • PHP
  • E-Commerce
  • MySQL
  • Web Ac­ces­si­bil­i­ty
Read more
Image: How to reset MySQL/MariaDB root passwordREDPIXEL.PLshut­ter­stock

How to reset MySQL/MariaDB root password

For­get­ting 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…

  • Security
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: What are the best MySQL optimize performance techniques for Linux?rangizzzShut­ter­stock

What are the best MySQL optimize per­for­mance tech­niques for Linux?

The per­for­mance of a MySQL or MariaDB database sig­nif­i­cant­ly impacts ap­pli­ca­tion speed. With the right op­ti­miza­tions, queries can be ac­cel­er­at­ed, resources used more ef­fi­cient­ly, and bot­tle­necks avoided. This article guides you step-by-step on how to optimize MySQL/MariaDB on a…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to connect a MySQL/MariaDB database to a Linux cloud server with PHPOleksiy Markshut­ter­stock

How to connect a MySQL/MariaDB database to a Linux cloud server with PHP

By con­nect­ing MySQL to a Linux server, you can link your database with a Linux cloud en­vi­ron­ment. In this article, we’ll show you how to do it step by step: from creating a test database and accessing it via a PHP script to querying data. You’ll also find trou­bleshoot­ing tips for…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fix “error establishing a database connection” in MySQL/MariaDBOllyyshut­ter­stock

How to fix “error es­tab­lish­ing a database con­nec­tion” in MySQL/MariaDB

The “error es­tab­lish­ing a database con­nec­tion” often blocks access to websites and ap­pli­ca­tions using MySQL or MariaDB. Our article provides a step-by-step guide to iden­ti­fy­ing and fixing the cause. Learn how to check cre­den­tials, reset passwords, and test con­nec­tions from the…

  • Database
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: What are the key differences in a MariaDB vs. MySQL comparison?kentohShut­ter­stock

What are the key dif­fer­ences in a MariaDB vs. MySQL com­par­i­son?

MySQL is one of the most widely used database man­age­ment systems worldwide. The open-source software has been available since 1995 and is con­sid­ered the standard solution for re­la­tion­al databases. However, MariaDB is becoming an at­trac­tive al­ter­na­tive. We compare both systems and…

  • Database
  • MySQL
  • SQL
  • MariaDB
  • Com­par­i­son
Read more
Image: How to import and export MySQL/MariaDB databaseRDVectorShut­ter­stock

How to import and export MySQL/MariaDB database

If you want to back up or restore MySQL or MariaDB databases, you can use the command line to do so. This tutorial walks you through the process of importing and exporting databases—both in MySQL and MariaDB. In this dedicated article, you’ll learn how to create an empty…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: What are the top 6 MySQL alternatives?Connect worldshut­ter­stock

What are the top 6 MySQL al­ter­na­tives?

MySQL is one of the best-known solutions in the re­la­tion­al database segment. But if you’re seeking a NoSQL companion to your SQL database or are aiming to get around rigid table struc­tures al­to­geth­er, it makes sense to explore NoSQL options. In this article, we’ll take a look at…

  • Database
  • MySQL
  • SQL
  • Com­par­i­son
Read more