We have the following scenario: Server A runs a web server with phpMyaAmin, which connects to Server B. In this case we are using Debian packages, so Server A is assumed to be running Debian, Ubuntu, Mint or another Debian
MySQL replication without the downtime
This is just a copy from the origin article https://plusbryan.com/mysql-replication-without-downtime The original site has been taken down. Since this is very useful, I am posting the original content here for future reference. Setting up MySQL replication without the downtime I clearly
PhpMyAdmin and changed MySQL data directory
Very often you would like to change the default data location of MySQL for obvious reasons. If you do that and you don’t change the phpmyadmin settings accordingly, you will not be able to login via phpmyadmin. You will constantly
Set up a MySQL user dedicated to backups
It is not a good idea to use the root MySQL account to do backups. So, let’s create a user dedicated exclusively to doing backups. Log on to MySQL as root: mysql -u root -p Then create the new user