Tag: Database

Using PhpMyAdmin to import databases can help us in a few different situations, like when moving a database from one server to another, updating a table that is being developed elsewhere, or even restoring content from a backup. PhpMyAdmin helps make all those processes easy to accomplish through our browser.

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.

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.

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.

This tutorial assumes you’ve already logged in to PhpMyAdmin. Now let’s familiarize ourselves with databases and PhpMyAdmin.

PostgreSQL supports many client authentication methods, but in this case we’re only going to concern ourselves with two: password and md5.

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.

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.

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.

 

What to Know Before Listing MySQL Databases — 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.