• Home
  • Linux
  • Ubuntu
  • Debian
  • CentOS
  • Linux Commands
  • About Us
  • Donate
TecNStuff
Menu
  • Home
  • Linux
  • Ubuntu
  • Debian
  • CentOS
  • Linux Commands
  • About Us
  • Donate

Tag: mysql

29 June 2021

[Solved] Unknown collation: utf8mb4_0900_ai_ci

Written by Admin
[Solved] Unknown collation: utf8mb4_0900_ai_ci
A collation means a predefined rules to compare and sort character strings in a database server. Generally, this error occurs during the database restoration on another server. In this guide, we will show you how to fix Unknown collation: utf8mb4_0900_ai_ci error. Let us discuss the cause and solution about the issue: Problem – Unknown...
Read More about [Solved] Unknown collation: utf8mb4_0900_ai_ci
General Articles Leave a Comment
14 October 2020

How to Create and Select MySQL Database

Written by Admin
How to Create and Select MySQL Databases
MySQL is the most popular and open-source relational database management system. In this article we will show you how to create MySQL or MariaDB database through the command line. Prerequisite# Make sure MySQL or MariaDB is already installed on your system. User account should have privileges to perform actions or have root user account....
Read More about How to Create and Select MySQL Database
MySql Leave a Comment
05 October 2020

BackUp and Restore MySQL/MariaDB Database

Written by Admin
How to BackUp and Restore MySQL Database with Mysqldump
The mysqldump is a utility used to backup and restore MySQL or MariaDB database using command line. It is creating a set of SQL statements while taking backup and those are used while restoring. In this tutorial we will show you how to backup and restore MySQL or MariaDB databases from the command line...
Read More about BackUp and Restore MySQL/MariaDB Database
Linux Commands Leave a Comment
25 May 2020

How to Check MySQL Version

Written by Admin
How to Check the MySQL Version
MySQL is one of the most popular open-source RDBMS (Relational database management system). MySQL provides some features for particular version numbers and on particular platforms only, so knowing which version is running on your server is really important. In this quick tutorial, we’ll explain how to check the MySQL or MariaDB version on your...
Read More about How to Check MySQL Version
Linux Commands Leave a Comment
10 May 2020

How to Install LEMP Stack on Ubuntu 20.04

Written by Admin
How To Install LEMP Stack on Ubuntu 20.04
The LEMP is a short name that describes a Linux operating system, with an Nginx (pronounced like “Engine-X”) web server. The backend data is stored in the MySQL or MariaDB database and the dynamic processing is handled by PHP. This tutorial describes how to install a LEMP stack on an Ubuntu 20.04 server. We...
Read More about How to Install LEMP Stack on Ubuntu 20.04
Ubuntu Leave a Comment
09 May 2020

How to Install Apache, MySQL, PHP (LAMP) on Ubuntu 20.04

Written by Admin
How to Install Apache, MySQL, PHP (LAMP) on Ubuntu 20.04
A LAMP stack is short form of Linux, Apache, MySQL and PHP. Here, L means Linux operating system, A for Apache web server, M is for MySQL database, P for PHP programming language. In this guide, we’ll install Apache 2.4, MySQL 8.0 and PHP 7.4 (LAMP) on Ubuntu 20.04 LTS (Focal Fossa) system. Prerequisites#...
Read More about How to Install Apache, MySQL, PHP (LAMP) on Ubuntu 20.04
Ubuntu Leave a Comment
01 May 2020

How to Install MySQL on Ubuntu 20.04

Written by Admin
How to Install MySQL on Ubuntu 20.04
MySQL is most popular open-source database management system. MySQL installation on Ubuntu is very easy and it’s commonly being a part of the popular LAMP and LEMP stacks. This tutorial explain how to install MySQL on Ubuntu 20.04 Focal Fossa systems. Install MySQL on Ubuntu# MySQL version 8.0 is the latest version of MySQL...
Read More about How to Install MySQL on Ubuntu 20.04
Ubuntu Leave a Comment
28 April 2020

How to Install WordPress with Apache on CentOS 8

Written by Admin
How to Install WordPress with Apache on Debian 10
WordPress is the popular and widely used blogging and content management system in the world. PHP processing and MySQL/MariaDB database are used as a backend in WordPress. It is simplest way to create a Blog, Portfolio Website, webshop etc. In this tutorial, we will show you how to install WordPress with Apache on CentOS...
Read More about How to Install WordPress with Apache on CentOS 8
CentOS Leave a Comment
24 April 2020

How to Install WordPress with Nginx on CentOS 8

Written by Admin
How to Install WordPress with Nginx on CentOS 8
WordPress is the most popular and widely used to create websites, blogs, webshop and much more. PHP processing and MySQL or MariaDB database are used as a backend in WordPress. In this tutorial, we will show you how to install WordPress with Nginx on CentOS 8 system. Prerequisites# We are going to use LEMP...
Read More about How to Install WordPress with Nginx on CentOS 8
CentOS Leave a Comment
09 April 2020

How to Install MariaDB on CentOS 8

Written by Admin
How to Install MariaDB on CentOS 8
MariaDB is an open-source relational database management system and a drop replacement of MySQL DB server. It is a fork of MySQL and managed by the original MySQL developers. MariaDB is a multi-user, multi-threaded SQL database server. In this article you will learn how to install and secure MariaDB on CentOS 8 server. Install...
Read More about How to Install MariaDB on CentOS 8
CentOS Leave a Comment
1 2 … 4 Next →
DigitalOcean Referral Badge

Popular Posts

© 2020 TecNStuff All rights reserved. This website is using and storing cookies on your browser. By using this website you agree our Privacy Policy.  Follow us -  Twitter | Facebook