Linux Tutorials on the topic “mysql”

• Ubuntu 16.04 (LTS) LAMP server tutorial with Apache, PHP 7, and MySQL

  Author: Till Brehm • Tags: apache, linux, mysql, php, ubuntu, web server • Comments: 135 • Updated: Oct 18, 2017

  LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache 2.4 web server on an Ubuntu 16.04 (Xenial Xerus) server with PHP 7 support (mod_php) and MySQL / MariaDB and how to setup an SSL certificate with Let's encrypt. Additionally, I will install PHPMyAdmin to make MySQL administration easier. A LAMP setup is a perfect basis for CMS systems like Joomla, Wordpress or Drupal.

  read more... | add comment | view as pdf | print

• Setting, Changing And Resetting MySQL Root Passwords

  Author: SamTzu • Tags: mysql • Comments: 31 • Updated: Oct 05, 2017

  Setting, Changing And Resetting MySQL Root Passwords. This tutorial explains how you can set, change and reset (if you've forgotten the password) MySQL root passwords. Time and again I see problems like mysqladmin:  connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)'. So I thought it's time to remind you how to solve MySQL related password problems. If you are just looking for a quick fix how to reset a MySQL root password you can find that at the bottom of this tutorial.

  read more... | add comment | view as pdf | print

• How To Install MariaDB Galera Cluster on Ubuntu 16.04

  Author: Hitesh Jethva • Tags: linux, mysql, server, ubuntu • Comments: 0 • Published: Sep 26, 2017

  MariaDB Galera is a multi-master cluster for MariaDB. In this tutorial, we will explain how to setup MariaDB Galera Cluster 10.1 with 3 nodes running on Ubuntu 16.04 server. We will also test database replication between all the nodes.

  read more... | add comment | view as pdf | print

• Install and Configure LEMP Stack in Debian 9

  Author: Matt Vas • Tags: debian, linux, mysql, nginx, php • Comments: 0 • Published: Sep 12, 2017

  This tutorial will guide you on how to install and configure LEMP stack (Nginx with MariaDB and PHP7) on the latest release of Debian 9. These pieces of software are widely used on servers on the internet today to deploy dynamic websites or interactive web applications.

  read more... | add comment | view as pdf | print

• Configure WordPress with W3 Total Cache and CloudFlare CDN in LAMP

  Author: Matt Vas • Tags: apache, debian, linux, mysql, php • Comments: 1 • Published: Sep 05, 2017

  This guide will show you how to increase WordPress website load speed with W3 Total Cache Plugin and a CloudFlare CDN free account. In this tutorial, Wordpress CMS system is installed on top of a LAMP stack (Linux + Apache HTTP server + MariaDB RDBMS and PHP) on a Debian 9 server.

  read more... | add comment | view as pdf | print

• Deploy WordPress on top of FAMP in FreeBSD 11.1

  Author: Matt Vas • Tags: apache, freebsd, mysql, php • Comments: 0 • Published: Aug 31, 2017

  This guide will show how to install and configure the most popular open source CMS used on the internet, Wordpress, on top of FAMP in FreeBSD 11.x latest release. FAMP is an acronym which describes the following software bundle: FreeBSD 11.1 Unix-like operating system, Apache HTTP server, one of the most popular open-source web server on the internet, MariaDB RDBMS (relational database management system), which is a fork of MySQL database engine, and PHP programming server-side language.

  read more... | add comment | view as pdf | print

• How to Install MySQL Server with phpMyAdmin on FreeBSD 11

  Author: Liptan Biswas • Tags: apache, freebsd, mysql • Comments: 0 • Published: Aug 07, 2017

  In this tutorial, we will install MySQL with phpMyAdmin along with Apache web server with PHP 5.6. MySQL is a free and open source relational management system. It stores data in tabular format. It is the most popular way of storing the data into the database. phpMyAdmin is also a free and open source application used to administrate a MySQL server instance through a rich graphical user interface.

  read more... | add comment | view as pdf | print

• How to Install SonarQube on Ubuntu 16.04

  Author: Hitesh Jethva • Tags: linux, mysql, nginx, programming, server, ubuntu, web server • Comments: 1 • Published: Aug 01, 2017

  SonarQube is a free and open source quality management system platform that can be used to automate code inspection. It can analyze source code files, calculate a set of metrics and show the result on the web based dashboard. It is written in Java language and also supports other languages like Perl, PHP, and Ruby.

  read more... | add comment | view as pdf | print

• How to configure MySQL Multi-Master Replication on Oracle Linux

  Author: shahril bin kamaruzzaman • Tags: centos, linux, mysql • Comments: 1 • Published: Jun 12, 2017

  This tutorial explains how to setup and configure MySQL multi-master replication on Oracle Linux. Please note that even though the configuration is made under Oracle Linux, yet the steps and configuration are mainly the same to CentOS and Red Hat Linux.

  read more... | add comment | view as pdf | print

• How to Enable SSL and Remote Connections for MySQL on CentOS 7

  Author: Muhammad Arul • Tags: centos, linux, mysql • Comments: 1 • Published: May 22, 2017

  In this tutorial, I will show you step by step to configure MySQL securely for remote connections with SSL. MySQL is an open source relational database system that works on many Operating Systems including Windows, Linux, MacOS and FreeBSD. It is probably the most popular OpenSource RDBMS and a central component of the LAMP and LEMP Stacks.

  read more... | add comment | view as pdf | print

Embed docs directly on your website with a few lines of code.