Software Developer. Computer Geek. INTJ.

Tag MySQL

Find MySQL users with no privileges

This finds MySQL users with no global or database privileges.

Find MySQL users with access to databases that don’t exist (have been deleted)

Useful for finding users who had permission to access databases that have since been deleted…

Script to download MySQL database & files from live to development server

This is a script I use on a lot of sites to copy the database (MySQL) and any uploaded files to the development site, and modify the database as required.

Download MySQL database from cPanel to development server (shell script)

This is a tiny script I used to download my live site database onto my development server when I used a web host that used cPanel, but didn’t give me access to mysqldump over SSH (because they have Jailshell enabled).

© 2021 Dave James Miller — Powered by WordPress

Theme by Anders NorenUp ↑