Tag: Database
Using PhpMyAdmin to search for records and information in your database can quickly help you get the information you need without having to run advanced search queries. This tutorial assumes you have already logged in to PhpMyAdmin, and shows how to search by keyword and for a range of records.
Running SQL Queries on a Database with PhpMyAdmin
In this tutorial, we will explore how to run SQL queries on a database within PhpMyAdmin. SQL stands for Structured Query Language. SQL statements or queries are used to perform database tasks such as searching, updating, or retrieving data from a database.
How to Install Libreoffice on Ubuntu 16.04
If you are looking to collaborate with your coworkers or employees and create and share documents on your Ubuntu VPS server without taking up space on your local computer system, LibreOffice is the perfect tool for you. Formerly known as OpenOffice (based on StarOffice) this tool has evolved largely from the vast community of developers that contribute to its success daily. This powerful tool is currently in use by millions around the world as a free and open-source alternative to the Microsoft Office Suite of tools.
Becoming Familiar with Databases in PhpMyAdmin
This tutorial assumes you’ve already logged in to PhpMyAdmin. Now let’s familiarize ourselves with databases and PhpMyAdmin.
Update Your PostgreSQL Password in Linux
PostgreSQL supports many client authentication methods, but in this case we’re only going to concern ourselves with two: password and md5.
Installing WordPress using WP-CLI
WordPress has a great GUI-based installation process however some use cases call for CLI! Or, maybe you just feel more at home in a terminal, either way this article will show you how to get your WordPress site setup with just a terminal, using WP-CLI, and maybe a sprinkle of SSH.
Creating and Deleting a PostgreSQL Database on Ubuntu 16.04
PostgreSQL (pronounced post-gress-Q-L) is a household name for open source relational database management systems.
It is object-relational, meaning that you’ll be able to use objects, classes in database schemas, and the query language. In this tutorial, we will be demonstrating some essentials like how to create, list, and delete a Postgres database.
Install and Connect to PostgreSQL 10 on Ubuntu 16.04
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 database schemas and in the query language. In this tutorial, we will show you how to install and connect to your PostgreSQL database on Ubuntu 16.04.
Select a MySQL Database on Linux via Command Line
Pre-Flight Check
- These instructions are intended for selecting a MySQL database 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 login to the MySQL server from the command line with the following command:
Pre-Flight Check
- These instructions are intended for showing (listing) all MySQL databases via the command line.
- I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.