Databases
How to Allow Remote MySQL Connections
Managing a MySQL database doesn’t always mean accessing it from the same server where it’s hosted. In many situations, especially…
Tag: MySQL
Databases
How to Backup and Restore MySQL Stored Procedures & Triggers
The database is the most crucial part of any application, and as a developer, ensuring the safety of your database…
Databases
How to Set Up MySQL Master-Master Replication
MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server.…
Databases
Shell Script to Backup MySQL Database
In this tutorial, you will find a simple bash script for backing up a MySQL database. The script takes a…
Databases
How to Set Up MySQL Master-Slave Replication
MySQL replication is a process where a master server replicates its data to one or more slave servers. This can…
Databases
Error in query (1548): Cannot load from mysql.proc. The table is probably corrupted
Error: Below issue generally comes with database incompatibilities with the current version of MySQL. It may happen due to MySQL…
Databases
MySQL Database Backup RPM
I had created this rpm few months back. Now it is available for all users. This rpm have a simple…
Databases
How To Create a New User and Grant Permissions in MySQL
MySQL is a relational database management system, used for storing data in form of tables and records. You can insert,…
Databases
MySQL Database Backup to FTP Server – Shell Script
As a system administrator, you need to take backup on daily basis. Backups are very useful to recover data from…
Databases
How to Reset MySQL Root Password in Linux
Resetting the MySQL root password in Linux is a crucial task for database administrators, especially when access is lost or…