Tag Archives: mysql

How to configure remote and secure connections for MySQL on Ubuntu 16.04 VPS

In this article, we will show you how to configure remote and secure connections for MySQL on Ubuntu 16.04 VPS.  If you are using an unencrypted connection to connect to your remote MariaDB/MySQL server, then everyone with access to the network could monitor and analyze the data being sent or received between the client and the server. This guide should work on other Linux VPS systems as well but was tested and written for an Ubuntu 16.04 VPS. Login to your VPS via SSH ssh my_sudo_user@my_server The steps in this tutorial assume that you have installed MySQL 5.7 with the [ ]
https://www.rosehosting.com/blog/how-to-configure-remote-and-secure-connections-for-mysql-on-ubuntu-16-04-vps/

Advertisements

How to Fix the Missing MySQL Extension Error in WordPress

If you are setting up WordPress on a new Linux VPS for the first time you may face some problems like missing some PHP extensions. One example is missing the MySQL extension and this is a common problem since the extension doesn t come by default with many operating systems. In this tutorial we will help you to fix the problem with the missing extension and complete the WordPress installation successfully. Missing a PHP extension is not something you should be worried about. If you see the following message on your screen when trying to access the WordPress installation via web [ ]
https://www.rosehosting.com/blog/how-to-fix-the-missing-mysql-extension-error-in-wordpress/

How to install MySQL on Ubuntu 16.04

MySQL is the world s most popular open-source relational database management system (RDBMS). It is widely used for building web applications and is an important part of the LAMP open-source web application software stack. In this tutorial we are going to Continue reading
https://www.rosehosting.com/blog/how-to-install-mysql-on-ubuntu-16-04/

Create a MySQL Database and User through cPanel

There are different ways to create a MySQL database and user. In one of our previous blog articles about MySQL database administration, we described how to create a new MySQL database and user through the command line which is pretty Continue reading
https://www.rosehosting.com/blog/create-mysql-database-and-user-through-cpanel/

Install Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu

In this tutorial we are going to show you how to install Prosper202. Made by Tracking202, Prosper202 is a self-hosted application that lets you track and optimize all your marketing campaigns. It s open source and easy to install on a Continue reading
https://www.rosehosting.com/blog/install-prosper202-with-nginx-mysql-and-php-fpm-on-ubuntu/