Category: MySQL

0

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 accounts.id=sys_users.account_id;” 2. Get client login details from Plesk. ———————————————– mysql...

3

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 :...