WordPress MYSQL import fails with Unknown collation: ‘ utf8mb4_unicode_ci’

With the recent update, WordPress changed their encoding standard from utf8 to utf8mb4, which is only supported starting with MYSQL server version 5.5.3  released in 2010. If you are running a MYSQL server version 5.5.2 or below chances are that you will fail to import the database with error message –  Unknown collation: ‘ utf8mb4_unicode_ci […]

See More

Changing the Default Document Directory in Plesk for a Domain or Subdomain

Summary: Problem: Normally the domains point to www, public_html, or httpdocs folder. Change this to some other folder. e.g., httpdocs/Somefolder. Solutions: 1. Goto /var/www/vhosts/<domain>/conf 2. Create file vhost.conf 3. enter this line DocumentRoot /var/www/vhosts/(yourdomain.com)/httpdocs/(path-to-new-document-root) 4. Save File   5. enter this command in your ssh terminal /usr/local/psa/admin/bin/websrvmng -a. Full Description How to change the default […]

See More

ERROR: PleskFatalException Unable to connect to database: saved admin password is incorrect.

In case you are unable to Log-in your Plesk Control Panel and you are getting following Error Message: ERROR: PleskFatalException Unable to connect to database: saved admin password is incorrect. Follow these steps to recover MySQL admin password:- –  Stop your MySQL server as  ::  sudo service mysql stop –  Open your MySQL configuration file  […]

See More