Tagged: database

Hide database from user

Hide database from user

These two queries will restrict a user to a single database, so that the user can only see, update, and delete tables from that single database: Replace USER with the MySQL username Replace USERDATABASE...

Perl Script to Backup MySQL Databases

Perl Script to Backup MySQL Databases

The script uses ‘mysqldump’ command to backup the data. That means that thebackups are in the SQL dump format. The dumps of all the databases that are backed up are compressed and stored in the destination...