Tag: howto

Grant privileges to a Mysql user?

HowTo GRANT privileges to a Mysql user? Create a database: mysql> create database dbname; and grant the privileges using the following query: mysql> grant all on dbname.* to ‘dbuser’@’localhost’ identified by ‘password’; The user ‘dbuser’ will now have access to database ‘dbname’ locally using the password ‘password’. Using the above […]

Howto: Re-create/re-install a VPS

How to re-create/re-install a OpenVZ VPS? 1) Make a backup of the configuration file: cp -p /etc/sysconfig/vz-scripts/VEID.conf /etc/sysconfig/vz-scripts/VEID.conf_old 2) Stop the VPS: vzctl stop VEID 3) Destroy/Terminate the VPS: vzctl destroy VEID 4) Create the VPS using the OS templates stored under /vz/template/cache directory: vzctl recreate VEID –ostemplate os-template-name 5) […]

iopp: howto get i/o information per process

We all know and love vmstat, but wouldn’t it be nice to get such information on a per process basis, to be able to better understand what is causing i/o problems? This is exactly what iopp, written by Mark Wong and released as open source does: “It’s a custom tool […]

howto: turn off open_basedir in Plesk

osted by admin     Category: Plesk Management How to turn off open_basedir in Plesk? By default Plesk applies open_basedir restriction for all the domains on the server. You can remove the open_basedir restriction lines from the httpd.include file located at /home/httpd/vhosts/example.com/conf/ directory but Plesk will overwrite the file again once […]