Category: MySQL


Plesk and MYSQL

1. Getting all the domain account information from Plesk ————————————————————————mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e “select login,password,home from sys_users INNER JOIN accounts on;” 2. Get client login details from Plesk. ———————————————– mysql...


MySQL table repair

Query : All the database has corrupted. I wasn’t able to connect my website properly neither i was able to fix it manually. Can any one help me to fix the issue??? Solution :...