Ayad knowledge base

Please refer to this article

https://support.office.com/en-us/article/Change-a-user-name-and-email-address-in-Office-365-fb5ac074-e203-4e1f-9843-b9d1a3e03297

/scripts/pkgacct –skiphomedir USER

Solutions

yum install ea4-experimental
yum install ea-php56-php-memcache
yum install ea-php56-php-memcached
yum install ea-memcached

That should fix the issue. i have tried it and fixed my issue. 
Reference

https://forums.cpanel.net/threads/installing-memcache-and-memcached-with-easyapache4.566261/

The issue can be fix by run the following command

/scripts/restartsrv_queueprocd

1) Click the “Export” tab for the database

2) Click the “Custom” radio button

3) Go the section titled “Format-specific options” and change the dropdown for “Database system or older MySQL server to maximize output compatibility with:” from NONE to MYSQL40.

4) Scroll to the bottom and click “GO”.

I’m not certain if doing this causes any data loss, however in the one time I’ve tried it I did not notice any. Neither did anyone who responded in the forums linked to above.

Reference

http://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel/29939906#29939906

1- plesk db  databasename < databasename.sql

or

2- mysql -uadmin -p”`cat /etc/psa/.psa.shadow`” databasename < databasename.sql

sed -i 's/original/new/g' file.txt

• sed = Stream EDitor
• -i = in-place (i.e. save back to the original file)
• The command string:
  • s = the substitute command
  • original = a regular expression describing the word to replace (or just the word itself)
  • new = the text to replace it with
  • g = global (i.e. replace all and not just the first occurrence)
• file.txt = the file name

Run the following command

/usr/local/psa/admin/bin/httpdmng –reconfigure-all

Resolution

To solve the problem and reconnect Plesk with the MySQL server, follow these steps:

1. Stop the MySQL server (but not “Plesk SQL Server”) from running on port 3306 using the Plesk Services Monitor tray utility.
2. Edit the MySQL configuration file, %plesk_dir%\\Databases\\MySQL\\Data\\my.ini , and add the line skip-grant-tables to the [mysqld]section.
3. Start the MySQL server.
4. Log into MySQL without the password:

“%plesk_dir%\\Databases\\MySQL51\\bin\\mysql.exe”

5. Change the password for the MySQL administrator:

UPDATE mysql.user SET Password = password(‘newpassword’) WHERE User = ‘admin’;

6. Remove skip-grant-tables from the MySQL configuration file and restart the service.

password should be reset already and no more issues

Reference

https://support.plesk.com/hc/en-us/articles/213947045-How-to-reset-the-MySQL-administrator-s-password-Windows-

Cause

Domain’s application pool does not support 32 applications.

Resolution

1. Open IIS->domains , find your domain name and name of application pool that domain uses.
2. Make sure that “Enable 32-Bit Applications” is enabled in IIS->Application pool->domain’s application pool->Advanced settings .