Tag: mysql

AMAZON RELATIONAL DATABASE SERVICE (RDS)

About RDS Amazon RDS is a web service to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, re-sizable capacity for a relational database and manages common database administration tasks.   Importing database…

Read More »

HOW TO INSTALL LAMP ON A REMOTE SERVER USING ANSIBLE PLAYBOOK

About An Ansible Playbook is an organized unit of scripts that defines work for a server configuration managed by ansible. Ansible Playbooks are written in YAML. An Ansible playbook contains one or more plays, each of which define…

Read More »

SETUP MASTER – SLAVE REPLICATION BETWEEN TWO MYSQL SERVERS IN UBUNTU

ABOUT MySQL Master – Slave replication is a process that enables data from one MySQL database server (the master) to be copied automatically to another MySQL database server (the slave). It is usually used to spread read access…

Read More »

HOW TO RESET MYSQL OR MARIADB ROOT PASSWORD ON UBUNTU 18.04

Determine which database server you are using, by version check mysql -V Next, shut down database server sudo systemctl stop mariadb (for mariadb) sudo systemctl stop mysql (for mysql) Now restart it in safe mode to reset root…

Read More »