Categories
How To

How to Install phpMyAdmin with Apache on Debian 10 (Buster)

(: June 25, 2019) In today’s guide, we will discuss how you can Install phpMyAdmin on Debian 10 (Buster). phpMyAdmin is a free and Open source Web application written in PHP for administering MySQL and MariaDB database servers. It is mostly used by Developers and DBAs to interact with a database server because of its […]

Categories
How To

Install and Configure phpMyAdmin on RHEL / CentOS 8

(: June 25, 2019) How do I Install phpMyAdmin on RHEL / CentOS 8?. In this blog post, we will cover how to install and Configure phpMyAdmin on RHEL 8. phpMyAdmin is an open source software tool written in PHP for administering MySQL and MariaDB database servers from a Web interface. phpMyAdmin has support for […]

Categories
How To

How to Install Latest phpMyAdmin on Ubuntu 18.04 / Debian 9

(: May 2, 2019) In our today’s guide, we will discuss how you can Install Latest phpMyAdmin on Ubuntu 18.04 / Debian 9. The phpMyAdmin package available on Ubuntu 18.04 & Debian 9 repository is a bit old. If you need to install the latest phpMyAdmin on Ubuntu 18.04 / Debian 9, you’ll have to […]

Categories
How To

Install and Configure phpMyAdmin on Fedora 30/29/28

(: May 2, 2019) In this guide, we will look at how to Install and Configure phpMyAdmin on Fedora 30/29/28. PHPMyAdmin is an open source software tool written in PHP, intended to handle the administration of MySQL over the Web interface. phpMyAdmin has support for a wide range of operations on MySQL, MariaDB, and Drizzle. […]

Categories
How To

Apache Error: No matching DirectoryIndex (index.html) found [SOLVED]

Pre-Flight Check These instructions are intended specifically for solving the error: No matching DirectoryIndex (index.html) found. I’ll be working from both sxi.io Web Core Managed CentOS 6 and CentOS 7 servers, and I’ll be logged in as root. Apache Error for One General Reason This error may occur when attempting to access applications that have […]

Categories
How To

Deleting Fields from Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

Error: Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]

This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL. Once in awhile, perhaps on a Development server, MySQL won’t be setup with a root password. The aforementioned configuration is generally thought of as against best practices however, if it is what you’re dealing with, then it could […]

Categories
How To

Modifying Fields in Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How to Install and Configure phpMyAdmin on Ubuntu 16.XX

PhpMyAdmin is a user-friendly graphical interface to interact with MySQL/MariaDB and is a cornerstone of any webhosting environment. Because of this, it is also a commonly exploited part of the server and should be connected to with https://. If you have not yet installed an SSL on your domain, its good idea to do so […]

Categories
How To

Inserting Fields into Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

Creating Tables in a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

Copying a Database Table with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

Deleting Tables from a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

Renaming Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How To Assign a User to a MySQL Database in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

Exporting Databases and Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How to Install and Configure phpMyAdmin on CentOS 6

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. Pre-Flight Check These instructions are intended specifically […]

Categories
How To

How To Install and Configure phpMyAdmin on Fedora 23

PhpMyAdmin is an open-source tool used for the administration of MySQL. In addition to offering the capability to perform administrative 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. Pre-Flight Check These instructions are intended for installing […]

Categories
How To

How to Install and Configure phpMyAdmin on Fedora 20

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. Pre-Flight Check These instructions are intended specifically […]

Categories
How To

How To Change a MySQL Database User’s Password in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]