change mysql 8 password

How To Reset MySQL 8 Root Password On Ubuntu 20.04

We can easily change and reset the MySQL 8 root password on ubuntu 20.04 using the following methods. Let’s see, how to reset MySQL 8 root password. How To Reset MySQL 8 Root Password On Ubuntu 20.04 Suppose, you have … Read more

sqlyog create database

How To Create Database And User In SQLyog On Windows

How To Create Database And User In SQLyog On Windows We have already installed SQLyog on the windows machine and MariaDB server installed on CentOS 7. Let’s see, how to create, access database and user using SQLyog community software for … Read more

mysql master slave configuration in linux

Configure Master and Slave MySQL Replication On Linux

Configure Master and Slave MySQL Replication On Linux You need two machines for this setup one for Master and another for a slave. I will install the MySQL 5.7 version. you can configure master-slave replication and also show the master … Read more

revoke user privileges mysql

How To Revoke Access From User In MySQL CentOS 7

I have created two databases and I will provide full access to both databases to both users and then I will revoke the database permission. Let’s see how to revoke access from the user. you can remove user permission from … Read more

mysql backup gz

MySQL Database Backup In GZ Format On Linux 7

Suppose if you have a database with 10 GB size, So it will reduce this size to approx 1 GB. We can import or take a complete MySQL database backup tool or with a dump using GZ format in Linux. … Read more

Enable MySQL General Query

How To Enable MySQL General Query Log On Linux

The Server writes information to this file when the client connects and disconnects. MySQL query used to find out the error in a client and want to know what exactly the client sent to mysqld. This writes to log each … Read more

install mariadb 10 ubuntu

Step To Install Mariadb 10 Database Server On CentOS 7

By default, the MariaDB database 5.5 version will be available in Linux without any separate repository. you can install MariaDB centos using the repository and can do MariaDB show users. MariaDB is almost the same as MySQL database server in … Read more