Get the following error when try to use PHPMyAdmin in the Plesk CP: “#1045 – Access denied for user ‘pma_xxxxxxx’@’localhost’ (using password: YES)”

RESOLUTION Make sure that Plesk PHPMyAdmin user exists in mysql.user table and has right password and privileges. Username and password can be found in $PRODUCT_ROOT_D/admin/htdocs/domains/databases/phpMyAdmin/ (Note, since Plesk 8.1 the file is $PRODUCT_ROOT_D/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php), for example:

Atomic ASL linux setup

I use Centos 5 and plesk 8.4.0, and i made: 1) wget 2) sh 3) nano /etc/yum.repos.d/CentOS-Base.repo 4) [atomic] name=Atomic Rocket Turtle – $releasever – Atomic PSA-Compatible RPMS baseurl=$releasever/$basearch [plesk] name=Plesk Server Administrator baseurl=$releasever/$basearch gpgcheck=0 5) yum update 6) restart At plesk webadmin, plesk version is psa v8.4.0_build84080514.18 os_CentOS 5

How to protect PLESK?

You could install: Firewall: CSF, APF, ASL Protection Tools: MOD Security, MOD Evasive, fail2ban, BFD Importent: Keep your Software (Plesk, PHP, WordPress …) uptodate. Running PHP in safe mode (could help maybe)! The best thing is to buy Atomic Secured Linux It is more than a Firewall! Its a full package of security and always …

Nameserver setup on 2 Plesk servers 1.) MySQL Access Rights On your Plesk server: Create a MySQL user eg.: secondarydns Using phpmyadmin, grant this user the SELECT option only for the table domains of the psa database. Also for maximum security you should set the hostname from which this user will logon.