Tag: Database
MySQL Select Database on Linux Via Command Line
When working with MySQL in the command line, it is important to ensure proper selection of the database you wish to work with. Administering a server has its challenges without unnecessary errors due to an incorrect database selection. This article shows you how to select a MySQL database in Linux via the command line.
Create a MySQL Database on Linux via Command Line
While the are many ways to create databases, system administrators benefit from knowing how to create a MySQL database in Linux via the command line. Knowing more than one way to accomplish a task provides flexibility in case the usual way you perform it is not an option. Use this tutorial to create a MySQL database via the command line.
Data security is essential to developers, business owners, and system administrators. A vital element of securing data is password management. This guide will teach you how to change a MySQL password in Linux using the command line.
What is the Default Password for PostgreSQL?
To answer what is the default password for the PostgreSQL user, there isn’t one. When connecting to PostgreSQL on Linux for the first time, many admins have this question, especially if they are from the MySQL world. One important task is how to access PostgreSQL. This tutorial walks you through setting up the default user for PostgreSQL and connecting to the service.
How to Repair a MySQL Database in cPanel
II. How to Create a MySQL Database in cPanel
III. How to Delete a MySQL Database in cPanel
IV. How To Create a MySQL Database User in cPanel
V. How to Assign a User to a MySQL Database in cPanel
VI. How to Change a MySQL Database User's Password in cPanel
VII. How to Remove a User from a MySQL Database in cPanel
VIII. How to Delete a MySQL Database User in cPanel
IX. How to Check a MySQL Database for Errors in cPanel
X. How to Repair a MySQL Database in cPanel
XI. How to Manage a MySQL Database with phpMyAdmin in cPanel
After checking your database for errors in cPanel, the next step is to repair your database. The system will let you know if any errors are found and simple ones can be fixed right in cPanel. This feature saves you from having to deep dive into easy database fixes.
How to Install and Configure Zabbix on Ubuntu 20.04
Introduction
Zabbix is an open-sourced tool used to monitor various IT components such as servers and hardware that they are running, cloud services, whole networks, etc. Zabbix can monitor the network health and integrity of your servers. All monitoring can be done through Zabbix’s web-based frontend. This means that you can quickly check the status of your servers from anywhere! This article describes how to install the Zabbix monitoring tool, create a database, and configure the frontend on Ubuntu 20.04.
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 ArangoDB on Ubuntu 20.04
What is ArangoDB?
ArangoDB is a high availability and scalable multi-model NoSQL database that natively works with graphs and documents and includes a full-text search. It is a free, open-source software developed and maintained by ArangoDB GmbH. The system supports three different data models with one database core and includes a unified query language called AQL (ArangoDB Query Language). This query language is declarative and allows the combination of different data access patterns in a single query. The software can be implemented on multiple systems, including Windows, macOS, Linux, Kubernetes, Docker, and on our Managed Cloud Servers. It has a strong community support base on GitHub, StackOverflow, Google Groups, and Slack.
How to Fix Typical WordPress Errors
Let’s face it. At some point, while running your WordPress site, you will run into issues and errors and may ultimately have to ask yourself, How Do I Fix My WordPress Site?
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.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.