
MySQL Root Access Denied fix for Plesk
When you setup a Dedicated server with a host like 1and1 they setup an admin account for root access on MySQL but the password is a mystery and login from outside the localhost isn’t possible anyway. After tons of frustration and searching I finally found the fix for this. The reason this is so important is mainly for backups, there’s no other way to backup all of you databases quickly other than using an account which can access all of your databases. When running Plesk in the default Reseller mode access to databases is limited to each domain and one