Step-by-Step MySQL Installation on Ubuntu
Install and secure MySQL on Ubuntu with copy-paste commands, service management, firewall rules, and tests to get running fast.
How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 16.04
A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the Apache web server. The site data is…
How To Use HAProxy to Set Up MySQL Load Balancing
HAProxy is an open source software which can load balance HTTP and TCP servers. In the previous article on HAProxy we configured load balancing for HTTP and in this one we’ll do the same for MySQL. All your MySQL servers have to be configured to perform Master-Master replication as load balancing involves both reading and writing to all the backends.
How To Install MariaDB on Ubuntu 18.04
MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement for MySQL. This tutorial will explain how to install MariaDB on an Ubuntu 18.04 server, and verify that it is running and has a safe initial configuration.
How To Use Stored Procedures in MySQL
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.
How To Install MySQL on CentOS
MySQL is an open-source database management system. CentOS prefers MariaDB by default, a fork of MySQL managed by the original MySQL developers and designed as a replacement for MySQL. Unless you have a specific use-case for MySQL, see the [How To Install MariaDB on CentOS](https://www.progressiverobot.com/how-to-install-mariadb-on-centos-7/) guide.
How To Install and Secure phpMyAdmin on Ubuntu 12.04
This tutorial covers installing phpMyAdmin on a LAMP stack. Additionally it includes the steps on how to secure it with the .htaccess file. phpMyAdmin is an free web software to work with MySQL on the web—it provides a convenient visual front end to the MySQL capabilities.
Como usar a extensão PHP PDO para realizar transações do MySQL em PHP no Ubuntu 18.04
O autor selecionou a Open Sourcing Mental Illness para receber uma doação como parte do programa Write for DOnations. Uma transação de MySQL consiste em um grupo de comandos em SQL relacionados de…
How to Create and Insert a Table in MySQL: A Beginner’s Guide
Learn how to create tables and insert data in MySQL using simple SQL commands. This tutorial covers syntax and common errors for beginners.
How To Install and Configure Zabbix to Securely Monitor Remote Servers on Ubuntu 18.04
Zabbix is open-source monitoring software for networks and applications. In this tutorial, you will configure a Zabbix-based monitoring system on two Ubuntu 18.04 machines. One will be configured as the server, and the other as a client that you’ll monitor. The server will use a MySQL database to record monitoring data and use Apache to serve the web interface.
