VestaCP Upgrade MYSQL 5.6 for CentOS6

VestaCP Upgrade MYSQL 5.6 for CentOS6

rpm -Uvh

You can edit file:  /etc/yum.repos.d/mysql-community.repo

yum update mysql-server
service mysqld restart
chkconfig mysqld on

This will update your MySQL to MySQL 5.6


See also: Upgrade to PHP 5.6 in VestaCP CentOS

Upgrade to PHP 5.6 in VestaCP CentOS

Default VestaCP instillation for CentOS 6.7 comes with PHP5.4 .

1. Install the REMI and EPEL RPM repositories

wget && rpm -Uvh epel-release-latest-6.noarch.rpm

wget && rpm -Uvh remi-release-6*.rpm

2. Edit /etc/yum.repos.d/remi.repo

vi /etc/yum.repos.d/remi.repo

Under the section that looks like [remi] and [remi-php56] change:

from enabled=0 to enabled=1

Save remi.repo and exit

3. Upgrade PHP 5.3 to PHP 5.6

yum -y upgrade php*


See also: VestaCP Upgrade MYSQL 5.6

How to Fix error: realpath(): open_basedir restriction in effect

During Magento installation on VestaCP CentOS you may have problem:

[error] PHP Warning:  realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/home/admin/web/ in /home/admin/web/ on line 99

For fixing that error add /tmp into /home/admin/conf/web/httpd.conf Apache config file open_basedir:

<Directory /home/admin/web/>
        AllowOverride All
        Options +Includes -Indexes +ExecCGI
        php_admin_value open_basedir /home/admin/web/
        php_admin_value upload_tmp_dir /home/admin/tmp
        php_admin_value session.save_path /home/admin/tmp

And then reboot server


Create MySQl Database and User


1. Login to MySQL with root credentials

$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 5.5.49-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

2. Create database mydb

mysql> create database mydb;
Query OK, 1 row affected (0.00 sec)

3. Create user my_user

mysql> create user 'my_user'@"localhost" identified by "qwP3$5";
Query OK, 0 rows affected (0.00 sec)

4. Give all privileges to user my_user

mysql> grant all privileges on mydb.* to 'my_user' with grant option;
Query OK, 0 rows affected (0.04 sec)

5. And then exit

mysql> exit

How to configure DHCP on CentOS / RHEL

For example we need configure DHCP client on eth0 for getting dynamic IP’

1. Start editing /etc/sysconfig/network-scripts/ifcfg-eth0 file using text editor:

# vi /etc/sysconfig/network-scripts/ifcfg-eth0

Sample configuration:

HWADDR=your MAC address

Save and close just edited ifcfg-eth0 file

2. Restart network service:

# /etc/init.d/network restart


See also: How To Configure Static IP On CentOS 6

How to properly Uninstall (remove) VMware vSphere Data Protection 6.1 from VMware vCenter Server


How to properly Uninstall (remove)  vSphere Data Protection 6.1 from VMware vCenter Server

To uninstall vSphere Data Protection from vCenter Server:
1. Power off vSphere Data Protection appilance
2. Remove any attached disks
3. Right click the appliance and Delete from disk.
4. Remove the vSphere Data Protection plug-in from vCenter Server using the Managed Object Browser

Open https://yourvcenterip/mob in a web browser and login with your credentials:

– Click content > extensionmanager.

– Click unregisterextension.

– In the text field provided enter:

   For VDP 5.1: com.vmware.vdp, for VDP 5.5/5.8/6.x: com.vmware.vdp2  then com.vmware.vdp2.config

– Click Invoke Method to remove the plug-in

How to Create Virtual Interface on CentOS 6 Linux

How to Create Virtual Interface on CentOS  6 Linux

Creating Virtual Interface and Assign Multiple IP Addresses

Let’s assume you want create new virtual interface ifcfg-eth0:0 device and assign new IP

Network device files are located in /etc/sysconfig/network-scripts/ directory.

# cd /etc/sysconfig/network-scripts/
# cp ifcfg-eth0 ifcfg-eth0:0

Then edit new ifcfg-eth0:0 file with your favorite text editor (vi for me). We need to change only two parameters DEVICE, and IPADDR

# vi ifcfg-eth0:0


Then you need save and restart the network service

# /etc/init.d/network restart

Now your new interface with IP ready for use.