mysql

  Physical/Cold Backup This backup method, also known as a cold backup, involves making a physical copy of MySQL instance files to a backup location. No backup tool is required; only a simple Unix-based command is used. It’s considered the safest way to preserve your MySQL instance. In this backup method, you’ll back up the…

DBA Account Up until now, we’ve predominantly used the root account on localhost for database management. However, as we expand access to remote users, it’s essential to understand how to establish non-root user accounts for remote access. This setup will allow users to connect via various clients like the standard MySQL Client, the newer MySQL…

MySQL Architecture MySQL Architecture is divided into layers , its quit simple but for now we will focus on outer layer ‘End-User/Client Layer’ and ‘physical storage’ End-User/Client Layer: This is where applications or tools that need to work with MySQL, like scripts, come in. They use something called a MySQL connector—a type of software that…

installing Mysql 8 community edition involve below steps 1.Add MySQL Repository package. 2. Install MySQL Community Server from the repository. 3. Enable MySQL server to auto-start. 4. Start MySQL server. 5 .Verify if MySQL is running. Follow the steps in the provided link to add the repository and install MySQL. click here installing MySQL percona…