Database MySQL How to Setup MySQL 5.7 Replication on Ubuntu 16.04 Setting up MySQL 5.7 master-slave replication on Ubuntu 16.04. This article focus on how to setup database replication between two MySQL 5.7 servers on Ubuntu 16.04 LTS server. Database replication is mostly used for backups, improved availability and some also use it to run analytic queries and reports. If you don’t already have MySQL 5.7 […] Written by Clemence Ayekple September 3, 2018September 3, 2018
Database Troubleshooting How to Reset MySql Root password on MacOS 10.13 You might have had a situation where you forgot your MySQL root password. How will you solve such a problem in MacOS High Sierra. Here are some few steps to solving that issue that is resetting mysql root password. Step 1: Stop MySQL service You can do that by simply going to preference pane and click […] Written by Clemence Ayekple June 26, 2018July 10, 2018
Database How to Backup MySQL Database using mysqldump Backup MySQL Database using mysqldump One of the most common ways to backup MySQL database is to use a command called “mysqldump“. Backing Up The basic syntax of the command to backup mysql with mysqldump is: mysqldump -u your_username -p database_to_backup > backup_file_name.sql Restoring Dumped Data To restore a database backup we created with mysqldump, […] Written by Clemence Ayekple March 23, 2018September 24, 2018
Troubleshooting Reset MySQL root password via command line – mysql 5.7 The MySQL root password allows the root user to have full access to the MySQL database. You must have (Linux) root administrator access to the server to reset MySQL root password. Use the following steps to reset a MySQL root password by using the command line interface. Stop The MySQL Service (Ubuntu And Debian) Run […] Written by Allan Philip Barku November 13, 2016August 5, 2018
Database Troubleshooting How to reset MySQL root password on Ubuntu Server MySQL root Password Reset Just for some weird reason, you forget your root password, either you have changed it recently and just can not remember what you typed. Well do not give up just yet, there is a way out. To reset the password you would need physical access to the server, either via ssh or directory […] Written by Allan Philip Barku December 22, 2015August 5, 2018
