While trying to use mysql in plesk I am getting the following error :

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Solution :

echo “use psa; truncate lockout;” | mysql -u root -p`cat /etc/psa/.psa.shadow`     —> this can be a solution, but I have not tested that with 100% success

« Prev：How to check if VPS has memory bottleneck What is the root mysql password in plesk server.：Next »