Tag: MySQL

phpMyAdmin is an open source tool used for the administration of MySQL. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more.

• These instructions are intended for removing a MySQL user 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:

• 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:

Preflight Check

• These instructions are intended for creating a MySQL database on Linux via the command line.
• I’ll be working from a Liquid Web Core Managed CentOS 7 VPS server, and I'll be logged in as root.

Create a MySQL Database

First we'll log in to the MySQL server from the command line with the following command:

• These instructions are intended for setting the password for all MySQL users named root on Linux via the command line. However, they can also be followed to change the password for any MySQL user.
• 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:

Installation instructions for Content Management Systems (CMS) often require you to create a MySQL database for the application. But just how is that done on a cPanel server?

Computers have been built to enhance the way we store, retrieve, and process information since their original invention. While initially designed to perform mathematical calculations, their power and capabilities grew along with the desire to more efficiently process different types of data. In order to harness this burgeoning capability for data storage and retrieval, computer scientists developed databases.

This is part 4 in an ongoing series on WordPress. Please see Part 1: WordPress Tutorial 1: Installation Setup and Part 2: WordPress Tutorial 2: Terminology and Part 3: WordPress Tutorial 3: How to Install a New Plugin, Theme, or Widget.

This is part 3 in an ongoing series on WordPress. Please see Part 1: WordPress Tutorial 1: Installation Setup and Part 2: WordPress Tutorial 2: Terminology and Part 4: WordPress Tutorial 4: Recommended WordPress Plugins. Please note that this guide is primarily intended for customers utilizing a Linux server running cPanel. If you do not have a Linux server with cPanel please see the documentation at wordpress.org for further assistance.

Many customers tell us how overwhelming setting up their first website feels. Between DNS, e-mail, document roots, software versions, and all the other details involved in setting up a website there is a lot to keep track of.