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 Install and Integrate BigBlueButton with WordPress Including BigBlueManager

In this tutorial, we will show you how to set up a BigBlueButton server on Ubuntu 16.04 and integrate it with WordPress using the BigBlueButton plugin.

BigBlueButton is a free and open-source web conferencing system that can be used for online learning, online meetings, and webinars. It’s based on HTML5 and runs entirely within your web browser. BigBlueButton provides high-quality audio, video, and screen sharing using the browser’s built-in support for web real-time communication (WebRTC) libraries. It can be also integrated into WordPress, allowing bloggers to create and manage meeting rooms to interact with their readers.

These excellent features make BigBlueButton one of the best tools for tutors, teachers, schools, colleges, universities, and even entire school districts. At the time of writing this tutorial, the latest version of BigBlueButton is 2.2 and it can be installed on Ubuntu 16.04.  The BigBlueButton authors plan to support Ubuntu 18.04 and Ubuntu 20.04 for the next release of BigBlueButton, but their current recommended version is 16.04. Let’s get started with the installation. Let’s get started with installing BigBlueButton on an Ubuntu 16.04 VPS.

Read moreHow to Install and Integrate BigBlueButton with WordPress Including BigBlueManager

How and Why to Change the Default SSH Port on Linux

In this tutorial, we will show you how to change the SSH default port in Linux, and go over why changing this default port is a good idea. IMPORTANT: Before we go any further, you should understand that this is not a solution that will prevent or deter a determined hacker to attack your SSH service. It is merely a measure to help you avoid the thousands or automated bots running all the time scanning vast ranges of IP space searching for standard SSH ports being open. Preventing a determined hacker from brute-forcing your SSH service is beyond the scope of this article.

SSH, also known as Secure Shell, is the most widely-used protocol for connecting to and managing Linux systems remotely. SSH offers strong encryption and authentication along with excellent customizability, and using SSH gives you the freedom of accessing a remote machine. You can run services and software as if you were physically using the machine, no matter where you are.

By default, SSH runs on port 22. Since this is common knowledge, this port often becomes a target for brute force attacks. Because this provides full access to your server’s OS, people with malicious intent will often target port 22 more than any other port. Changing the default SSH port will prevent automated attacks that don’t spend the time to rotate ports when targeting a Linux Server. To protect your server from a brute force attack, you should change the default SSH port to something else.

Read moreHow and Why to Change the Default SSH Port on Linux

How to Install Let’s Encrypt on Ubuntu 20.04 with Apache

In this article, we will show you how to install the Let’s Encrypt client on your Ubuntu 20.04 VPS, issue an SSL certificate for your domain, and configure it with the Apache web server.

Let’s Encrypt is a certificate authority organization (CA) that allows anyone to obtain a free SSL certificate with simple and automated commands. In this tutorial, we will use a tool called certbot, which is an official part of EFF’s effort to encrypt the entire Internet. Thanks to this convenient tool, setting up an SSL certificate to protect your website’s visitors and improve your website’s security has never been easier. All SSL certificates provided by Let’s Encrypt can be used for production/commercial purposes without any costs or fees. Let’s begin with the installation and setup.

Read moreHow to Install Let’s Encrypt on Ubuntu 20.04 with Apache

How to Install a Mail Server with PostfixAdmin on Ubuntu 20.04

In this tutorial, we’ll be covering the process of setting up a mail server with Postfix, Dovecot, Postfixadmin and MariaDB on an Ubuntu 20.04 VPS. But first, what is PostfixAdmin?

PostfixAdmin is an open-source web-based application written in PHP that’s used to create virtual domains and email accounts for a Postfix mail server. Using PostfixAdmin, we can manage mailboxes & aliases, set quotas, configure vacation/out-of-the-office messages, and more. Plus, the web-based interface gives you the user-friendliness of a browser window with a UI.

PostfixAdmin allows us to use virtual email addresses and virtual mailboxes, so we do not need to create a new system user account for each email address. Considering all of these details, PostfixAdmin is a versatile tool and can be used for almost all of your mailing needs. This tutorial goes quite in-depth and may take some time to configure everything properly. Let’s get started with the installation steps.

Read moreHow to Install a Mail Server with PostfixAdmin on Ubuntu 20.04

How to Use Puppet Modules to Create a LAMP Stack on Ubuntu 20.04

Puppet is a powerful open-source configuration management tool that can be used to deploy, configure, manage, and maintain a server while accessing it remotely. Puppet is written in Ruby and helps you to deploy and manage a single server – all the way up to thousands of physical and virtual servers – all from a central location.

Puppet modules are collections of manifest files and data that allow Puppet to load and find classes, facts, functions, defined types, and tasks. With Puppet modules, you can install and update packages, create files and directories, and/or make any configuration changes quickly and easily. It aims to perform and automate almost any task, such as launching a LAMP environment, setting up virtual hosts, etc.

In this tutorial, we will show how to create a LAMP module to deploy a LAMP stack on the Puppet agent machine, both of which are Ubuntu 20.04 VPSes. Let’s begin.

Read moreHow to Use Puppet Modules to Create a LAMP Stack on Ubuntu 20.04

How to Install Flectra on Ubuntu 20.04 with Nginx as a Reverse Proxy

Flectra is a free and open-source CRM and ERP software that provides a lot of flexibility and customization that lets you meet the unique needs of your business.

Flectra is built using the Python programming language and PostgreSQL as its database backend. This software aims to help almost everyone, whether it’s a small startup or a large corporation. Flectra has a simple and user-friendly interface and a modular design that enables you to add or remove tools to make it work the way you need it to.

Flectra is a fork of Odoo Community and its main goal was to implement many features from Odoo Enterprise while still keeping it open for everyone to use.

In this tutorial, we will explain how to install Flectra on an Ubuntu 20.04 VPS using Nginx as a reverse proxy. The reverse proxy will allow you to access your Flectra instance from a domain name while also using the default port number. Let’s get started.

Read moreHow to Install Flectra on Ubuntu 20.04 with Nginx as a Reverse Proxy

How to Install Flectra on CentOS 8 with Nginx as a Reverse Proxy

Flectra is an open-source, powerful and customizable business management tool that helps you grow your business through its powerful modular design covering all essential aspects of most businesses.

Flectra integrates the capabilities of CRM and ERP systems into a single package. Flectra helps you modify and adapt your system to meet the unique needs of your business. This makes it the ultimate business app suite that gives you a scalable business management platform which provides you with all the freedom to make the software work for you and your business setup.

Flectra offers several features that cover almost every use case, including e-Commerce, Accounting, Sales Management, Websites, Marketing, Inventory Management, MRP, Reporting, Timesheets, and lots more.

In this tutorial, we will show you how to install Flectra on a CentOS 8 VPS using Nginx as a reverse proxy.

Read moreHow to Install Flectra on CentOS 8 with Nginx as a Reverse Proxy

How to Install Open Classifieds on CentOS 7

In this tutorial, we will learn how to install Open Classifieds on a CentOS 7 VPS.

Open Classifieds is a free, open-source, and powerful web application that can be used to create classifieds, advertisements, and listings sites, all in just a few minutes. It is simple, easy to use, secure, SEO-friendly and easy to administrate.

Open Classifieds also provides a beautiful web-based admin interface that helps you manage your website easily and effectively. It comes with many features, including SEO-friendly optimization, multi-language support, friendly URLs, robots.txt support, custom fields, social login, and lots more. Let’s get started with the installation.

Read moreHow to Install Open Classifieds on CentOS 7