Etiqueta: MySQL

How to Install MyWebSQL on Ubuntu 16.04

  In this tutorial we will show you how to set up MyWebSQL on Ubuntu 16.04 servidor. MyWebSQL is a free and open source web based WYSIWYG client for managing the databases on your server. It provides a simple and intuitive interface with the look and

How to Configure WordPress to use a Remote Database

WordPress is the most popular content management system (CMS) based on PHP and MySQL. When your WordPress CMS grows in traffic and you have outgrown your current server resources, a professional solution is to host your database on a separate database server. With this solution, vostè…

Instal·lar phpMyAdmin en Ubuntu 16.04

  phpMyAdmin is one of the most popular and widely used web-based database management tools. It a free and open source PHP application that allows the users to manage single or multiple SQL database servers locally or on a remote server using a web browser (GUI).

How to reset your WordPress admin password

  WordPress is a free and open-source content management system (CMS) based on PHP and MySQL which you can use to create a beautiful website. As of April 2016, WordPress is used by more than 26.4% of the top 10 million websites worldwide. Sometimes WordPress webmasters

How to set up MySQL Cluster on Ubuntu

The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). En aquest tutorial, we will show you how to set up MySQL Cluster on an Ubuntu 16.04 VPS. We will use a total of 4 virtual servers,

Instal·lar Ubuntu en una XWiki 16.04 VPS

XWiki is a free and open source advanced wiki software platform written in Java. It runs on servlet containers like JBoss, Tomcat etc. which uses a database such as MySQL or PostgreSQL to store its information. There are several methods of installing XWiki. In this tutorial,

Com instal · lar i configurar MongoDB en Ubuntu 16.04

Com instal · lar i configurar MongoDB en Ubuntu 16.04 MongoDB is a NoSQL database that offers a high performance, high availability, and automatic scaling enterprise database. MongoDB is a NoSQL database, so you can't use SQL (Structured Query Language) to insert and retrieve data, i això…

Install Cockpit CMS on Ubuntu 16.04

  En aquest article, we will show you how to install Cockpit CMS on an Ubuntu 16.04 VPS with PHP-FPM 7.0 and Nginx. Cockpit is open source self-hosted API-driven content management system (CMS) application written in PHP. Cockpit stores the data in an SQLite database so

How to setup MySQL replication on CentOS

In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servidors, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses:

How to Setup MySQL Master-Master Replication

How to Setup MySQL Master-Master Replication This article consolidates information from several sources into the format I use to setup MySQL Master/Master Replication. The beauty of Linux and open source is that there are many different ways to do this. Please take a look at my

Instal·lar WordPress amb Nginx en openSUSE

As you already know WordPress is a free and open-source content management system (CMS) based on PHP and MySQL which you can use to create a beautiful website, Bloc, or app. In this article we will install WordPress with Nginx on a openSUSE VPS. So follow

How to install WikkaWiki on an Ubuntu VPS

In this tutorial we will show you how to install WikkaWiki on an Ubuntu 14.04 VPS. WikkaWiki is a flexible, standards-compliant and lightweight wiki engine software written in PHP, which uses a MySQL database to store pages. It is easy to set up and easy to

How to Show All Users in MySQL

This is a common question most beginner MySQL users ask. We notice it all over the internet and on our blog too. It’s frequently asked because there are other MySQL commands for displaying information about the database, for example: SHOW DATABASES will list out all the