MyWebSQL is a powerful web interface designed to help handle all aspects of your MySQL server through a web browser. Made to be fast, easy-to-use, and readily accessible from anywhere, MyWebSQL allows you to keep track on your databases from any location, through any device. And with support for various MySQL servers, you also don’t need to worry about it supporting the one you currently use. If you’re looking for a web management tool, but you need something other than phpMyAdmin, then this is a solid choice to go with. In this tutorial, we will show you how to install MyWebSQL on your CentOS 7 machine or VPS. The installation process is fairly simple, and will not take long.
centos 7
How to Configure WordPress to use a Remote Database
WordPress is the most popular content management system (CMS) based on PHP and MySQL. When your WordPress CMS grows in traffic and you have outgrown your current server resources, a professional solution is to host your database on a separate database server. With this solution, you can optimize your database and your web server independently and both servers can grown on it’s own machine. In this tutorial we will guide you on how to configure WordPress to use a remote database, on a CentOS 7 based VPS.
Enable Proxy Settings for Yum Command on CentOS 7
In this article, we will show you how to enable proxy settings for yum command on CentOS 7. Yum is a package management tool that works with RPM packages. It is available on RedHat Enterprise Linux, CentOS, and older versions of Fedora, and it is the most convenient way to handle OS packages and their dependencies on these operating systems.
When a server can only be accessed through proxy servers, you need to configure yum to use a proxy server so you can install a RPM package, or update the currently installed yum packages.
To configure a proxy server so the system user can access and use yum commands is a fairly easy and straight-to-the-point task, and it shouldn’t take more than 5 minutes to configure it. Let’s get started.
How to Install phpMyAdmin on CentOS 7
This tutorial explains the process of installing one of the most popular open-source applications for managing MySQL databases – phpMyAdmin. phpMyAdmin is a free and open source web-based application written in PHP, used to easily manage MySQL databases through your favorite web browser instead of the MySQL command line interface. phpMyAdmin allows users to create, modify, rename and delete databases, tables or fields, execute SQL commands through the browser, import and export tables to a wide range of formats, create users and modify their privileges, and much more… We are going to install phpMyAdmin on a CentOS 7 VPS with Apache, MariaDB, and PHP
How to Install MySQL on CentOS 7
Let us show you how to install MySQL on your CentOS 7 server. MySQL is a relational database management system that functions through the use of a query system. Created in 1995, it’s an open-source project that is currently developed by Oracle, and has existed since 1995. It’s fast, written in C and C++, and is available on almost any system platform. Its features include cross-platform support, replication support, Unicode support, triggers, cursors, and much more. Since this is such a highly versatile and desirable database-management tool, most people want to install it on their Linux machines, but find that the built-in software repositories install MariaDB, which is a community-developed version of MySQL.
How to Set Up Nginx High Availability Cluster using Pacemaker on CentOS 7
In this tutorial, we will show you how to set up Nginx High Availability cluster using Pacemaker on CentOS 7. To have an Nginx server that can operate continuously without failure for a long time, we need to configure the server with active-passive Nginx instances. Pacemaker is an open source cluster manager software that achieves maximum high availability of your services. It’s an advanced and scalable High Availability cluster manager distributed by ClusterLabs, it manages all cluster services and use the messaging and membership capabilities of the underlying cluster engine.
How To Install Zabbix 3.4 Server On CentOS 7
In this tutorial, we will show you how to install Zabbix 3.4 on CentOS 7. Zabbix is an open source network monitoring software designed to monitor and track the status of various network devices, servers, virtual machines and other network hardware. It can use MySQL, PostgreSQL, SQLite, Oracle or IBM DB2 as a backend data storage. Zabbix back-end is written in C and the web front-end is written in PHP. Zabbix offers multiple monitoring options such as simple checks to verify the availability and responsiveness of standard services such as IMAP or HTTP without installing any software on the monitored machine.
List All Installed Packages with yum on CentOS 7
In this short tutorial, we will show you, how to list all installed packages with yum on CentOS 7 . Yum is the default package manager used in CentOS, used to interact with both individual RPM package files and many repositories. This tutorial was written for CentOS 7, but the commands in this tutorial should work on any server with Redhat, CentOS, or Fedora installed on it.