Articles
Many websites and applications start off with their web server and database backend hosted on the...
How To Connect to MySQL Managed Database via phpMyAdminIntroduction The phpMyAdmin tool allows users to interact with MySQL database management through...
How To Create a New User and Grant Permissions in MySQLIntroduction MySQL is an open-source relational database management system. It is commonly...
How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 22.04Introduction A “LAMP” stack is a group of open source software that is typically installed...
How To Install MariaDB on Debian 11Introduction MariaDB is an open-source relational database management system, commonly used as...
How To Install MariaDB on Rocky Linux 9Introduction MariaDB is an open-source database management system, commonly used as an...
How To Install MariaDB on Ubuntu 22.04Introduction MariaDB is an open-source relational database management system, commonly used as...
How To Install MySQL on Rocky Linux 9Introduction MySQL is an open-source database management system, commonly installed as part of...
How To Install MySQL on Ubuntu 20.04Introduction MySQL is an open-source database management system, commonly installed as part of...
How To Install MySQL on Ubuntu 22.04Introduction MySQL is an open-source database management system, commonly installed as part of...
How To Install and Secure phpMyAdmin on Ubuntu 22.04Introduction While many users need the functionality of a database management system like MySQL,...
How To Manipulate Data with CAST Functions and Concatenation Expressions in SQLIntroduction 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.04Introduction 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.04Introduction As your application or website grows, there may come a point where you’ve outgrown...
How To Use Nested Queries in SQLIntroduction Structured Query Language (SQL) is used to manage data in a relational database...
How To Use Sequelize with Node.js and MySQLIntroduction Sequelize is a Node.js-based Object Relational Mapper that makes it easy to work...
Understanding SQL and NoSQL Databases and Different Database ModelsIntroduction Since time immemorial, one of the most heavily needed and relied upon...
