Articles

How To Allow Remote Access to MySQL

Many websites and applications start off with their web server and database backend hosted on the...

How To Connect to MySQL Managed Database via phpMyAdmin

Introduction The phpMyAdmin tool allows users to interact with MySQL database management through...

How To Create a New User and Grant Permissions in MySQL

Introduction MySQL is an open-source relational database management system. It is commonly...

How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 22.04

Introduction A “LAMP” stack is a group of open source software that is typically installed...

How To Install MariaDB on Debian 11

Introduction MariaDB is an open-source relational database management system, commonly used as...

How To Install MariaDB on Rocky Linux 9

Introduction MariaDB is an open-source database management system, commonly used as an...

How To Install MariaDB on Ubuntu 22.04

Introduction MariaDB is an open-source relational database management system, commonly used as...

How To Install MySQL on Rocky Linux 9

Introduction MySQL is an open-source database management system, commonly installed as part of...

How To Install MySQL on Ubuntu 20.04

Introduction MySQL is an open-source database management system, commonly installed as part of...

How To Install MySQL on Ubuntu 22.04

Introduction MySQL is an open-source database management system, commonly installed as part of...

How To Install and Secure phpMyAdmin on Ubuntu 22.04

Introduction While many users need the functionality of a database management system like MySQL,...

How To Manipulate Data with CAST Functions and Concatenation Expressions in SQL

Introduction When you first create a table in an SQL database, you must define its overall...

How To Reset Your MySQL or MariaDB Root Password on Ubuntu 20.04

Introduction Forgot your database password? It happens to the best of us. If you’ve forgotten or...

How To Set Up a Remote Database to Optimize Site Performance with MySQL on Ubuntu 20.04

Introduction As your application or website grows, there may come a point where you’ve outgrown...

How To Use Nested Queries in SQL

Introduction Structured Query Language (SQL) is used to manage data in a relational database...

How To Use Sequelize with Node.js and MySQL

Introduction Sequelize is a Node.js-based Object Relational Mapper that makes it easy to work...

Understanding SQL and NoSQL Databases and Different Database Models

Introduction Since time immemorial, one of the most heavily needed and relied upon...