Your PHP installation appears to be missing the MySQL extension which is required by WordPress

Your PHP installation appears to be missing the MySQL extension which is required by WordPress

your php installation appears to be missing the mysqlYour PHP installation appears to be missing the MySQL extension error in WordPress, This error is triggered when the PHP code in your site is not compatible with the version of PHP your WordPress site is currently using. More specifically, the problem is with the outdated MySQL extension which was removed as of PHP 7.0.  In this tutorial, we will help you to fix the problem with php missing mysql extension, and complete the WordPress installation successfully.

Read moreYour PHP installation appears to be missing the MySQL extension which is required by WordPress

MySQL Show Users | RoseHosting

list MySQL usersToday we gonna guide you through how to show all users in the MySQL users Database.

A common question that most beginner MySQL users ask is “How do I see all of the users in my MySQL server?” Most of them assume that there is a show users command in MySQL, but there isn’t one. This is a common mistake because there are other MySQL commands for displaying information about the database. For example, SHOW DATABASES will show us all of the databases that are present in our MySQL Server, and SHOW TABLES will show us all the tables in the MySQL database that you have selected.

It’s not unusual for people to assume that there should be a SHOW USERS command in MySQL. Even though there isn’t a specific command for it, there are several ways to actually see the list of users and even filter them to see exactly what you need. This can all be done with the MySQL command line tool – let’s get started.

Read moreMySQL Show Users | RoseHosting

How to Install phpMyAdmin on CentOS 8

This tutorial explains the process of installing one of the most popular open source application 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 needing to use 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… Thanks to this tool, we will almost never need to use the MySQL command line again. We are going to install phpMyAdmin on a CentOS 8 VPS with Apache, MariaDB, and of course, PHP. Let’s begin.

Read moreHow to Install phpMyAdmin on CentOS 8

How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04

In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, and create a backup of the entire /var/lib/mysql directory.

We will create the backup of the databases using MySQL’s command, aptly named mysqldump. After that we will then show you how to perform a backup of the /var/lib/mysql directory where MySQL have been located. Performing regular backups of your database and database server is vital to protecting the data that you have on your server. This way, in case something goes wrong on your Ubuntu 20.04 VPS, or if MySQL breaks for some reason (incompatibilies or otherwise), you’ll have a safe backup that you can revert to and prevent the loss of your precious data.

Once you create a backup of MySQL databases and save them on your server or on a remote location, you can then always be able to restore the databases later from this backup, if needed. Creating a backup of MySQL database is essential for any website owner, and it should be done on a regular basis. Just follow the simple steps in this tutorial and your data will be redundant in no time. Let’s begin.

Read moreHow to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04

How to Install Apache Cassandra on Debian 9

In this tutorial, we will show you how to install Apache Cassandra on a Debian 9 VPS.

Apache Cassandra is a free and open-source distributed NoSQL database management system that provides High-Availability with no single point of failure. Cassandra does not use the table model seen in MySQL, MSSQL or PostgreSQL – rather, it uses a cluster model. It is designed to handle large amounts of data across commodity hardware. It provides linear scalability by adding a new machine to it without any interruption to applications. Apache Cassandra is used by many popular organizations including Apple, NetFlix, eBay, and Easou.

Let’s begin with the installation.

Read moreHow to Install Apache Cassandra on Debian 9

How to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database

In this tutorial we will guide you through the steps of installing WordPress on an Ubuntu 18.04 VPS with all necessary components, such as Apache web server, PHP and MySQL/MariaDB database server, and configure WordPress to use a database on a remote server.

WordPress is the most popular and most widely-used content management system (CMS). It is the CMS of choice for 26% of the entire web. It is based on PHP, and it stores its information in a MySQL database. The large amount of themes and plugins makes this CMS an excellent choice for someone that needs a user-friendly way to get their ideas onto a website that looks good. Let’s get started with the installation.

Read moreHow to Install WordPress on Ubuntu 18.04 and Configure it to Use a Remote Database

How to Install LAMP on Ubuntu 18.04

In this guide, we will explain how to install LAMP on Ubuntu 18.04.

LAMP (Linux, Apache, MySQL, PHP) is a combination of open source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL for data storage and management, and PHP for handling the dynamic content.

Installing LAMP on Ubuntu 18.04 is an easy task and should not take more than 10 minutes. Let’s begin with the installation process.

Read moreHow to Install LAMP on Ubuntu 18.04

How to Install phpPgAdmin on Debian 9

In this tutorial, we will show you how to install phpPgAdmin on a Debian 9 VPS.

PhpPgAdmin is an open-source web administration interface used for managing PostgreSQL databases. PhpPgAdmin is written in PHP and it makes the administration of PostgreSQL databases easier, not to mention the web-based GUI making everything more user-friendly and easier to use. Let’s begin with the installation process.

Read moreHow to Install phpPgAdmin on Debian 9

How to Install Apache CouchDB on Ubuntu 18.04

In this tutorial, we will show you how to install and set up Apache CouchDB on a VPS running Ubuntu 18.04.

Apache CouchDB is a free and open-source NoSQL database solution. Apache CouchDB has a document-oriented NoSQL database architecture and is implemented in the concurrency-oriented language Erlang; Apache CouchDB uses JSON to store data with documents, it uses JavaScript as its query language using MapReduce, and it uses RESTful HTTP for its API. CouchDB works smoothly with all latest modern web and mobile applications. All of this makes for a pretty seamless database experience. Let’s get started with installing CouchDB.

Read moreHow to Install Apache CouchDB on Ubuntu 18.04

How to Install Apache Cassandra on CentOS 7

In this tutorial, we will show you how to install and set up Apache Cassandra on a CentOS 7 VPS.

Apache Cassandra is a free and open-source, high performance, highly scalable distributed NoSQL database management system designed to handle a high volume of structured data across many commodity servers, providing high availability with no single point of failure. Cassandra is an excellent choice when downtime or data loss is unacceptable, where redundancy is key. Let’s begin with the installation.

Read moreHow to Install Apache Cassandra on CentOS 7