PLESK

What is the root password for MySQL?

Posted on February 11, 2012 by admin

Article ID: 427
Last Review: Jul, 5 2011

http://kb.parallels.com/427

Resolution

Parallels Plesk Panel renames ‘root’ mysql account to ‘admin’
when the Panel is installed.

To get root privileges in mysql simply login with the ‘admin’ username instead. The password is the same as the admin password in Parallels Plesk Panel.

On server with Parallels Plesk Panel versions 8.x, 9.x and above admin password is stored in file /etc/psa/.psa.shadow. Use the following command to get the
password:

~#
cat /etc/psa/.psa.shadow

Since version 10 admin password stored in file /etc/psa/.psa.shadow is encrypted. Use the following command to get admin password in plain text:

~# /usr/local/psa/bin/admin --show-password

Despite version of Parallels Plesk Panel you may use the following command to login to mysql with root privileges:

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

Posted in MySQL, PLESK Leave a comment

Apache configuration differences in Virtuozzo/Plesk

Posted on August 13, 2011 by admin

Overwriting config for MaxClients and ServerLimit is located in /etc/httpd/conf.d/swtune.conf. Changing those values in httpd.conf will not affect the server settings.

Posted in PLESK Leave a comment

Find changed files

Posted on July 27, 2010 by admin

find /var/www/vhosts -name “*” -type d ( -name statistics -o -name cache* ) -prune -o -mtime -0 -print

this will find all files changes within the past 24 hours excluding statistics and cache folders

Posted in PLESK Leave a comment

The server is saturated with SPAM. There are many messages in the queue. The mail is sent slowly.

Posted on August 14, 2011 by admin

APPLIES TO:

Plesk 7.5.x Reloaded
Plesk 9.x for Linux/Unix
Plesk 8.x for Linux/Unix

Resolution

First check that all domains have the option ‘Mail to non-existing user’ set to ‘reject’ but not to ‘forward’. You can change this setting to all domains using “Group Operations” in the “Domains” tab in Parallels Plesk Control Panel. The option “Reject mail to nonexistent user” is available since Parallels Plesk Panel 7.5.3. Read More

Posted in PLESK Leave a comment

PLESK misc.

Posted on February 28, 2010 by admin

/usr/local/psa/bin/psadump -F -z -f /backups –nostop –nostop-domain

rsync -a /home/httpd/vhosts/ /backups/

/usr/local/psa/admin/sbin/websrvmng -u –vhost-name=xfloyd.net

/usr/local/psa/admin/sbin/websrvmng –reconfigure-vhost –vhost-name=

vhost.conf
vhost_ssl.conf
In conf/vhost.conf add

ServerAlias *.mydomain.com

websrvmng -u –vhost=mydomain.com

0 */6 * * * rsync -a –delete /var/lib/mysql /backups/mysql/
0 0 */7 * * rsync -a –delete /var/www/vhosts/ /backups/
0 5 * * * rsync -a /var/www/vhosts/ /backups/
Backups FULL SERVER

/usr/local/psa/bin/pleskbackup –all /var/backups/plesk_full_backup.gz

Posted in PLESK Leave a comment

« Previous Page — Next Page »

The Blog

PLESK

What is the root password for MySQL?

Resolution

Apache configuration differences in Virtuozzo/Plesk

Find changed files

The server is saturated with SPAM. There are many messages in the queue. The mail is sent slowly.

Resolution

PLESK misc.

All Systems Go.