Failed to access MySQL via SSH using root account

Applicable to:

Failed to access MySQL via SSH using root account even if server root user password is modified.

To get root privileges in MySQL simply login with the admin username instead with one the following commands:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

# plesk db

If it is absolutely necessary, user root can be created with the following steps:

Log into the Plesk server via SSH;
Connect to MySQL:
# plesk db
Run the following command to create root user, put appropriate password replacing mypass:

MYSQL_LIN: CREATE USER 'root'@'localhost' IDENTIFIED BY PASSWORD 'mypass';
Grant all the privileges to this user:

MYSQL_LIN: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'