MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. This tutorial will explain how to install MySQL version 5.7 on an Ubuntu 18.04 server.
This tutorial covers the installation of phpMyAdmin on a LEMP server (as opposed to a LAMP server). phpMyAdmin is a free software to work with MySQL on the web—it provides a convenient visual front end to the capabilities of MySQL.
WordPress es un sistema de administración de contenido (CMS) gratuito y de código abierto que se desarrolla sobre una base de datos de…
This article covers the process required to transfer MySQL data between two servers. This tutorial includes steps on how to perform a MySQL dump, transfer the database with SCP, and then reimport it on the second server.
This tutorial will help you prepare to upgrade to MySQL 5.7 from earlier versions. It covers `sql_mode` with practical examples of query responses that get stricter. The tutorial also contains instructions for checking for warnings and errors, and contains a sample config file so you can test the new settings before upgrading. This article is from the [MySQL Team at Oracle](http://www.oracle.com/us/products/mysql/mysqlcommunityserver/overview/index.html).
This tutorial covers building a web application using the Laravel framework with Nginx as the web server and MySQL as the database all inside Docker containers along with configuration files for PHP, MySQL, and Nginx.
This article will teach you how to use CakePHP to create a small web application.
MySQL supports the use of stored procedures, which group one or multiple SQL statements for reuse under a common name. Using stored procedures, you can create reusable routines for common tasks to be used across multiple applications, provide data validation, or deliver an additional layer of data access security. In this tutorial, you’ll learn what stored procedures are and how to create basic stored procedures that return data and use both input and output parameters.
WordPress is a popular CMS and blogging software that can be used to quickly deploy sites. In this guide, we will demonstrate how to control your WordPress installation from the command line using a tool called wp-cli.
In this article, we will go over the specific features of a high-availability application setup and discuss its components at a high level. At the end of each section, we’ll link out to additional resources on the topic to support you as you consider methodologies and best practices.
Progressive Robot: Your Gateway to Comprehensive IT Solutions — Specializing in Web Development, Mobile App Development, and Expert IT Services.
© All Copyright by Progressiverobot.com
VAT Number ( 506152326 )
