MySQL root login
Plesk disable the root user. If you need to connect to mysql using a root level user then use user "admin" with your plesk admin password.
How to disable Open_base_directory restriction for a domain
Login to your server with root user, Then go to /var/www/vhosts/domainname.com/conf
and create a new file vhost.conf in that directory. Put this in that file.
<Directory /var/www/vhosts/domainname.com/httpdocs>
<IfModule mod_php4.c>
php_admin_value open_basedir None
</IfModule>
</Directory>
Save the file and exit. Then run this.
#On mandrake/redhat/fc
/usr/local/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=domainname.com
#On debian
/opt/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=domainname.com
And this.
(If you have debian)
/etc/init.d/apache2 restart
(If you have mandrake/fc/rdhat)
service httpd restart
Forgot plesk admin password
You can get it from cat /etc/psa/.psa.shadow
Plesk user locked out
* Log into your server via SSH, see our article Obtaining and using SSH for instructions on how to do this.
* Log into mysql as the user 'admin' A command like the one below will work:
mysql -uadmin -p psa
Enter the password that you use for the Plesk user 'admin'.
* To unlock all users in this table use the following command:
delete from lockout;
If you just want to display the users currently in this table you can use this instead:
select * from lockout;