MySQL

Reset MySQL MariaDB root password
How to Reset the MySQL/MariaDB Root Password
  • Technical matters

Learn basic MySQL/MariaDB disaster recovery and preparedness: How to reset the root MySQL/MariaDB password.

How to Reset the MySQL/MariaDB Root Password
Connect to a MySQL-MariaDB Database with PHP on a Linux Cloud Server
Connect to a MySQL/MariaDB Database with PHP on a Cloud Server Running Linux
  • Know-how

Learn how to connect to a MySQL/MariaDB database using PHP on a Cloud Server running Linux. This tutorial will cover connecting to a database on the same server as the PHP application, as well as how to connect to a database on a different Cloud Server.

Connect to a MySQL/MariaDB Database with PHP on a Cloud Server Running Linux
Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML Form
Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML Form
  • Web development

A PHP script is a convenient way to accept information 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 the PHP script.

Use PHP to Insert Information Into a MySQL/MariaDB Database From an HTML Form
Use MySQL With Ruby on Rails
How to use MySQL With Your Ruby on Rails Application
  • Know-how

Ruby on Rails uses SQLite as its database by default, but it also supports the use of MySQL. SQLite is an excellent alternative to a traditional database like MySQL, but it has some limitations, particularly with regards to concurrency and scaling to a high load, which may make MySQL a better choice for your project.

How to use MySQL With Your Ruby on Rails Application
Establishing a database connection MySQLMariaDB error
"Error establishing a database connection" MySQL/MariaDB error
  • Know-how

Learn how to fix "Error establishing a database connection” for MySQL/MariaDB on a Linux Server. With this guide you can easily fix the error for MySQL and MariaDB.

"Error establishing a database connection" MySQL/MariaDB error
Magento: an introduction to the open source software
What is Magento
  • CMS

Many contemporary content management 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 inconvenient to manage, making them a poor choice for larger projects. Some content management systems like Magento, however, are specially tailored for e-commerce, and therefore present a considerably more...

What is Magento
Creating backups with MySQLDumper
MySQLDumper: from installation to backup
  • Technical matters

“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.

MySQLDumper: from installation to backup
Composr
Composr 10: ocPortal’s WordPress alternative
  • CMS

The UK-based CMS ocPortal has undergone a rebrand: presenting Composr 10. Following in the footsteps of ocPortal 9, this CMS offers an all-in-one solution for web presences, with no need for extensions or templates. But who is Composr 10 suited to? And how does it compare to the CMS market leaders?

Composr 10: ocPortal’s WordPress alternative
Alchemy CMS: the CMS based on Ruby
Alchemy CMS: the open source project based on Ruby on Rails
  • CMS

While most content management systems are based on the PHP scripting language, Alchemy CMS uses a less common but more dynamic programming language: Ruby. There are also countless add-ons available from Ruby on Rails that can help to extend your web framework to create complex projects like company websites or online shops. Find out what makes this intuitive CMS a good bet for beginners.

Alchemy CMS: the open source project based on Ruby on Rails