Databases

Upgrade MySQL to 5.6 on Plesk VPS (POA)

Login to your VPS via terminal. Commands in order —————– wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm && sudo rpm -ivh mysql-community-release-el6-5.noarch.rpm   yum -y upgrade mysql-server   service mysqld restart   mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`   vi /etc/odbcinst.ini #change the following: /usr/lib64/libmyodbc5.so to /usr/lib64/libmyodbc5a.so   ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock   service mysqld restart   (to check if the sock […]

How to manage your MS SQL Database (POA)

Here are the steps if you need to mange your space or need access to the administrative admin URL. 1. Log into your Customer Control Panel with your main account’s username and password. 2. From the “Home” tab, click on the “Databases” link at the bottom left hand corner. 3. Click on the database you […]

How to create a DSN connection in the CP (POA)

Here are the steps to create a DSN connection through the POA customer control panel. 1. Log into the Customer Control Panel with your main account’s username and password. 2. Click on the “Websites” tab. Then select the domain you want to manage. 3. Click on the “DSN Management” link. 4. Click on the “Add […]

External access to MySQL databases (POA)

How can I access my MySQL database externally? If you have an account that allows your MySQL database to be access external, you will need to enable external access from your control panel. Here are the steps. Log in at Customer Control Panel with your main account’s username and password. Click on the “Databases” link […]