Oracle’s MySQL Operator for Kubernetes is a convenient way to automate MySQL database provisioning within your cluster. One of the operator’s headline features is integrated hands-off backup support that increases your resiliency. Backups copy your database to external storage on a recurring schedule. This article will walk you through setting up backups to an Amazon … [Read more...] about How to Backup Kubernetes MySQL Operator Clusters
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 … [Read more...] about 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 … [Read more...] about How to Fix the Missing MySQL Extension Error in WordPress
Create a new MySQL user and Grant Permissions to MySQL Database
In this tutorial, we will explain how to create a new user and grant permissions to that user in MySQL. MySQL is an open source relational database managed system(RDBMS) that enables users and applications to store, organize, and retrieve their data. It has an access control system that consists of permissions that the users can have within tables and databases, we … [Read more...] about Create a new MySQL user and Grant Permissions to MySQL Database
How to Install MySQL 5.7 on Linux CentOS and Ubuntu
How to Install MySQL 5.7 on Linux CentOS and Ubuntu MySQL is an open source relational database management system developed by Oracle corporation. The source code is released under GNU General Public License, and for proprietary, there is a paid edition that offers additional functions. MySQL is an important component of the LAMP and LEMP stacks. Many applications use these … [Read more...] about How to Install MySQL 5.7 on Linux CentOS and Ubuntu
How to install Apache, PHP 7.2 and MySQL on CentOS 7.4 (LAMP)
This tutorial shows how to install an Apache web server on CentOS 7 server with PHP (mod_php) and MySQL database. The acronym LAMP is short for Linux, Apache, MySQL, PHP. This updated tutorial shows the installation of the latest PHP versions (7.0, 7.1 and 7.2) on CentOS 7.4. 1 Preliminary Note In this tutorial, I use the hostname server1.example.com with the IP p … [Read more...] about How to install Apache, PHP 7.2 and MySQL on CentOS 7.4 (LAMP)
How to Reset WordPress Admin Password via MySQL Command Prompt
Have you ever forgotten your WordPress administrator password and did not have access to your e-mail account or haven’t configured your e-mail account properly in WordPress? Fear not, because in today’s tutorial we are going to learn how to reset the WordPress administrator password through the MySQL command prompt. Resetting WordPress Admin Password via MySQL Command Prompt, … [Read more...] about How to Reset WordPress Admin Password via MySQL Command Prompt
Using MySQL with Basic SQL Commands
Brief: Learn to use basic SQL commands in the open source database management system MySQL. MySQL is the most commonly used relational database manager. Its ease of use and open source license have greatly contributed to this popularity. Last week, I covered installing and configuring MySQL in Ubuntu. In this article I’ll be presenting to you multiple MySQL features, mostly … [Read more...] about Using MySQL with Basic SQL Commands
How to Install MySQL in Ubuntu Linux
Brief: This tutorial teaches you to install MySQL in Ubuntu based Linux distributions. You’ll also learn how to verify your install and how to connect to MySQL for the first time. MySQL is the quintessential database management system. It is used in many tech stacks, including the popular LAMP (Linux, Apache, MySQL, PHP) stack. It has proven its stability. Another thing that … [Read more...] about How to Install MySQL in Ubuntu Linux
How to Install MySQL on Ubuntu 18.04
In this tutorial, we will show you how to install and improve the security of MySQL on Ubuntu 18.04. MySQL is one of the most popular and widely-used open-source relational database management systems. It is used for building web applications such as WordPress, Drupal, Joomla, and Magento, and is an important part of the LAMP/LEMP open-source web application software … [Read more...] about How to Install MySQL on Ubuntu 18.04