Tag Archives: mysql

Basic MySQL Database Administration on Linux VPS – Part 2

In this tutorial, we will show you how to insert into and manipulate data in your tables. To find out how to create and manage databases and tables you can check out our previous tutorial: Basic MySQL database administration on a Linux VPS. If your Linux VPS is up and running and has MySQL installed, […]
https://www.rosehosting.com/blog/basic-mysql-database-administration-on-linux-vps-part-2/

Advertisements

How to List All Databases in MySQL

We will show you how to list all databases in MySQL. MySQL is an open-source relational database management system commonly used with web based applications like WordPress, Magento etc. In this tutorial we will show you how to list all databases in MySQL on a Linux VPS. Before you start listing all tables in MySQL, [ ]
https://www.rosehosting.com/blog/how-to-list-all-databases-in-mysql/

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 [ ]
https://www.rosehosting.com/blog/how-to-install-mysql-on-centos-7/

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/

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/