database

What is the Default Password for PostgreSQL?

When connecting to PostgreSQL on Linux for the first time many admins have questions, especially if those admins are...

Th8 12 · 58 sec read >

How to Install MariaDB 5.5 on Ubuntu 14.04 LTS

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and...

Th8 12 · 2 min read >

Installing Redis on Ubuntu 16.04/18.04

What is Redis?  Redis or “REmote DIctionary Server” is defined as an open source, “key-value” database storage medium, which...

Th8 12 · 3 min read >

Troubleshooting Microsoft SQL Server Error 18456, Login failed for user

Login errors with Microsoft SQL Server (MSSQL) are a fairly common issue and can be easily solved with some...

Th8 12 · 3 min read >

How To Delete Post Revisions using WP-CLI

There may be times when you need to clean up post revisions created on your site. This is possible,...

Th8 12 · 2 min read >

Create a MySQL Database on Linux via Command Line

MySQL via Command Line 101: Basic Database Interaction Change a Password for MySQL on Linux via Command Line Create...

Th8 12 · 1 min read >

How to Back Up MySQL Databases From The Command Line

MySQL via Command Line 101: Basic Database Interaction Change a Password for MySQL on Linux via Command Line Create...

Th8 12 · 1 min read >

MySQL Performance: MyISAM vs InnoDB

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database...

Th8 12 · 5 min read >

SQL Databases Migration with Command Line

What if you have dozens of SQL databases and manually backing up/restoring each database is too time-consuming for your...

Th8 12 · 2 min read >

Troubleshooting: MySQL/MariaDB Error #1044 & #1045 Access Denied for User

When using phpMyAdmin, it’s essential to have the correct user permissions to create edits/writes to the database.  Otherwise insufficent...

Th8 12 · 1 min read >

How to Install Nextcloud 15 on Ubuntu 18.04

Similar to Dropbox and Google Drive, Nextcloud is self-hosting software that allows you to share files, contacts, and calendars....

Th8 12 · 2 min read >

Searching Through a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III....

Th8 12 · 42 sec read >

Grant Permissions to a MySQL User on Linux via Command Line

MySQL via Command Line 102: Basic User Interaction Create a MySQL User on Linux via Command Line Grant Permissions...

Th8 12 · 1 min read >

MySQL Performance: Converting MySQL to MariaDB

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database...

Th8 12 · 20 min read >

MySQL Performance: Identifying Long Queries

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database...

Th8 12 · 5 min read >

MySQL Performance: MySQL vs. MariaDB

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database...

Th8 12 · 2 min read >

MySQL Performance: How To Leverage MySQL Database Indexing

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database...

Th8 12 · 4 min read >

How to Backup, Delete and Restore a PostgreSQL Database in CentOS 7 or Ubuntu 16

Listing databases Dump a database Dumping all databases Dump Grants Delete or Drop a Database Delete a Grant Restore a...

Th8 12 · 4 min read >

Common Postgres Tasks on CentOS 7

This guide walks you through some common tasks surrounding a Postgres server. In this tutorial, we’ll cover installing Postgres,...

Th8 12 · 3 min read >

Categories