Tag: MySQL
Check our vast MySQL tutorials, we have how to's that range from the basics, from setting up a user to advance topics like how to index your database.
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.
Remove a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
- 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:
Remove Permissions for a MySQL User on Linux via Command Line
- Create a MySQL User on Linux via Command Line
- Grant Permissions to a MySQL User on Linux via Command Line
- Remove Permissions for a MySQL User on Linux via Command Line
- Remove a MySQL User on Linux via Command Line
MySQL via Command Line 101: Basic Database Interaction
Create a MySQL Database on Linux via Command Line
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:
Change a Password for MySQL on Linux via Command Line
- Change a Password for MySQL on Linux via Command Line
- Create a MySQL Database on Linux via Command Line
- Select a MySQL Database on Linux via Command Line
- How to Delete A Database In MySQL/MariaDB
- How to Back Up And Restore MySQL Databases From The Command Line
MySQL via Command Line 102: Basic User Interaction
- 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.
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?
Database 101: What Is a Database?
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.
WordPress Tutorial 4: Recommended WordPress Plugins
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.
WordPress Tutorial 3: Install a 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.
5 Things You Need to Know About Your New Domain
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.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.