Enabling Plesk 12 Remote MySQL Connections 1. Connect to your server via SSH. 2. Log into MySQL. mysql -u admin -p`cat /etc/psa/.psa.shadow` 3. If you are attempting to grant non-localhost access to a user, you should use this line: GRANT…
Sometimes you need to make a dump of all MySQL databases, possibly prior to an upgrade or before you apply a required fix. I prefer to dump all database as .SQL as an added safety measure, just in case a…
How to Fix: Crashed MySQL Database If your database is marked as crashed and needs to be repaired you may find it will not backup (or migrate) using mysqldump. In these instances you need to login to mysql and run…