tag: MySQL

Ako nainštalovať MyWebSQL na Ubuntu 16.04

  In this tutorial we will show you how to set up MyWebSQL on Ubuntu 16.04 server. 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

Install phpMyAdmin on 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% z vrcholu 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). V tomto výukovom programe, 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,

Install XWiki on an Ubuntu 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,

Nainštalovať kokpitu CMS na Ubuntu 16.04

  V tomto článku, ukážeme vám, ako nainštalovať kokpitu CMS na Ubuntu 16.04 VPS s PHP-FPM 7.0 a Nginx. Kokpitu je open source self-hostované systém pre správu obsahu API-driven (CMS) aplikácia napísaná v 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 servery, 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:

Ako nainštalovať WebID aukčnej softvér na CentOS

V tomto výukovom programe, ukážeme vám, ako nainštalovať WebID na CentOS 7 VPS s Apache, PHP a MySQL nainštalovaná na ňom. WebID je aukčný softvér open source napísaný v PHP. Je to najlepšie riešenie pre vybudovanie aukčnej webové stránky. Tento výukový program…

Ako nastaviť MySQL majster hlavných replikácie

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

Install WordPress with Nginx on 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, blog, 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