Quick bash script to grep out MySQL passwords from Plesk’s PSA database. Script: [code language=”bash”]#!/bin/bash clear; echo "Searching MySQL user tables for: $1"; echo mysql psa -uadmin -p`cat /etc/psa/.psa.shadow` -e ‘SELECT domains.name AS domain_name, data_bases.name AS database_name, db_users.login, accounts.password FROM data_bases, db_users, domains, accounts WHERE data_bases.dom_id = domains.id AND db_users.db_id = data_bases.id AND db_users.account_id = […]
Quick bash script to grep out protected directory logins from Plesk’s PSA database. Script: [code language=”bash”]#!/bin/bash clear; you=`who am i | cut -d’ ‘ -f1`; echo -e "Hello $you, looking in the protected dirs password list for \033[33;1m$1\033[0m eh?"; echo mysql psa -uadmin -p`cat /etc/psa/.psa.shadow` -e ‘select pd.login, a.password, d.name, dirs.path from accounts a, pd_users […]
Quick bash script to grep out ftp passwords from Plesk’s PSA database. Script: [code language=”bash”]#!/bin/bash clear; echo "Searching the FTP password list for: $1"; echo mysql psa -uadmin -p`cat /etc/psa/.psa.shadow` -e ‘SELECT REPLACE(sys_users.home,"/home/httpd/vhosts/","") AS domain, sys_users.login,accounts.password FROM sys_users LEFT JOIN accounts on sys_users.account_id=accounts.id ORDER BY sys_users.home ASC’ | grep $1;[/code] Usage: [code gutter=”false”][root@mail bin]# grepftp […]
i accidentally imported a load of customers email addresses with quotes and commas in, so to remedy this, a short query: UPDATE customers SET email = REPLACE(REPLACE(email, ‘"’, ”), ‘,’ ,”) the first REPLACE replaces double quotes with nothing, and the second REPLACE replaces commas with nothing.
Sorting on two price fields in MySQL was a confusing thought at first, and was tempted to query then use php to do it. No! I needed a way to select my products and order them by price. But we have two prices, a “price” and “price_offer”, so we need to compare these values so […]
Ever forgotten your mysql root password? Indeed. Unless you know how to reset the mysql root password, you may find yourself either stuck, or re-installing mysql (as i did a few times many moons ago before i knew any better!) So lets reset mysql root password (seo-tastic I know) First thing to do is to […]