General Articles
(Resolved) Unknown collation: utf8mb4_0900_ai_ci
The collation utf8mb4_0900_ai_ci is a character set collation for MySQL databases, introduced in MySQL 8.0.1. It is based on the…
Tag: MySQL
General Articles
How To Import and Export MySQL Database
MySQL is an relation database management system to storing data in table format. It is an opensource database server available…
MySQL
How to Install MySQL 8.0 on Ubuntu 20.04
MySQL is the popular relational database management system used for storing structured data in table formats. It is open source…
MySQL
How to Check MySQL Version
MySQL is a relational database management system. At the writing time of this tutorial MySQL, 8 is the latest version…
Ubuntu
How To Install MySQL 8.0 on Ubuntu 18.04
MySQL is the most popular relational database management system. As an assumption MySQL is used by every third website running…
General Articles
MySQL case-sensitive Search with LIKE
The LIKE statement is used for searching records with partial strings in MySQL. By default the query with LIKE matches…
General Articles
Docker-compose for MySQL with phpMyAdmin
Docker-compose is an useful utility for managing multi-container docker applications. In our previous tutorial, I had discussed about the keep…
Databases
How To Install phpMyAdmin on Ubuntu 20.04
phpMyadmin is the best web based client for accessing MySQL servers. It is freely available to download and install on…
MySQL
How to Install MySQL on Ubuntu 20.04
MySQL is the popular relational database management system. This tutorial will help you to install and secure MySQL database server…
Ubuntu
How to Install Apache, MySQL & PHP on Ubuntu 20.04
A combination of Linux, Apache, MySQL, and PHP is known as LAMP stack is the popular web hosting environment for…