Archives - Tag

How to create a MySQL/MariaDB Database and Database User in Plesk

Introduction In this article, you will learn how to create a MySQL/MariaDB Database and Database User in Plesk. Step 1. Log into your Plesk with your server password by searching server_ip:8880 in your browser. Step 2. On the left side of the screen, select “Database,” then select “Add Database.”  Step 3. Fill in the details…

How to Start, Stop, and Restart MySQL Server on centos 7

Introduction MySQL is a database management system. This article will show you how to start, stop, and restart MySQL Server on CentOS 7, It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer…

Using mysqldump to Backup MySQL Databases

Description The mysqldump utility is part of MySQL and MariaDB. It makes it easier to make a backup of a database or system of databases. Using mysqldump makes a logical backup and generates the SQL statements needed to recreate the original database structure and data. NoteThe database management system needs to be functioning and available…

Explore Metabase data using MySQL

Introduction Metabase gives you a way to ask questions about data in your browser. Metabase not only lets you run SQL queries, but it also lets you analyse data without SQL, make dashboards, and track metrics. This guide explains how to connect MySQL to Metabase and then use a reverse proxy to deploy on NGINX….

How to install MySQL Relational Databases on Fedora 12

Many web and server programmes rely on MySQL as their database management system. Following this tutorial will make working with MySQL on Fedora 12 Linode much easier for newcomers. It is assumed that you have updated your system, followed the instructions in our Setting Up and Securing a Compute Instance guide, and logged into your…

Mysql 1030 got error 28 from storage engine

Introduction In this article, you have how to resolve Mysql 1030 got error 28 from storage engine. If you have any experience hosting MySQL systems, you have most likely run into the following error at some point. The following are some suggestions for how to correct it. Error 28 is a message that frequently appears…