Databases
How to drop a MySQL user using the command line interface
MySQL is an relational database management system provide authentication mechanism to prevent unauthorized access. In MySQL, user management is an…
Tag: MySQL
Databases
(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…
Databases
How to Allow Remote Connections to MySQL
MySQL is a popular open-source relational database management system that allows users to store, manage, and retrieve data. By default,…
Databases
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…
Databases
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…
Databases
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…
PHP
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…
DevOps & Cloud
Docker-compose with Persistent MySQL data
It is importent to keep data persistent for containers running databases. Docker provides you option to keep database files persistent…
Databases
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…
PHP
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…