Tag: Show Databases
How to Install and Configure ClickHouse on Ubuntu 20.04
What is ClickHouse?
ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.
How to Install Neo4j on Ubuntu 20.04
Introduction
In this tutorial, we will examine what Neo4j is, what it is used for, and how it is implemented. We will also install and configure the installation on an Ubuntu 20.04 server. Neo4j is a graphical database used to create data relationships. Other examples of graphical databases include:
MySQL Performance: How To Leverage MySQL Database Indexing
Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.
Grant Permissions to a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
Preflight Check
- These instructions are intended for granting a MySQL user permissions on Linux via the command line
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.
Login to MySQL
First we'll log in to the MySQL server from the command line with the following command:
Listing and Switching Databases in PostgreSQL
PostgreSQL (pronounced "post-gress-Q-L") is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language. As part of our PostgreSQL series, we’ll show you how to list and switch between databases quickly.
Remove Permissions for a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
- These instructions are intended for revoking a MySQL user permissions on Linux via the command line
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.
First we'll log in to the MySQL server from the command line with the following command:
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.