What is phpMyAdmin?

Introduction

PhpMyAdmin is an open source PHP tool designed to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating a database, running queries, and adding user accounts.

Supported Features
PhpMyAdmin can currently:

create, browse, edit, and drop databases, tables, views, columns, and indexes
display multiple result sets through stored procedures or queries
create, copy, drop, rename, and change databases, tables, columns, and indexes
maintenance server, databases, and tables, with server configuration proposals
execute, edit and mark any SQL statement, even batch queries
load text files into tables
create [1] and read table dumps
export [1] data to various formats: CSV, XML, PDF, ISO / IEC 26300 – OpenDocument Text and Spreadsheet, Microsoft Word 2000 and LATEX
import MySQL data and structures from OpenDocument spreadsheets as well as XML, CSV, and SQL files
administer multiple servers
add, edit and remove MySQL user accounts and privileges
check referential integrity in MyISAM tables
using query for example (QBE), create complex queries by automatically connecting required tables
create PDF charts of your database layout
globally search a database or a subset of it
transform data stored in any format using a predefined set of functions, such as displaying BLOB data as image or download link
track changes to databases, tables, and views
support InnoDB tables and foreign keys
support mysqli, MySQL’s enhanced extension see 1.17 What database versions does phpMyAdmin support?
create, edit, call, export, and discard stored procedures and functions
create, edit, export and drop events and triggers
communicate in 80 different languages
Hotkeys
PhpMyAdmin currently supports the following shortcuts:

READ  Connecting to SQL Server using PDO in PHP 2019

k – Toggle console
h – Go to homepage
s – Open settings
d + s – Go to database structure (as long as you are on the database related page)
d + f – Search database (as long as you are on the database related page)
t + s – Go to table structure (as long as you are on the table related page)
t + f – Lookup table (as long as you are on the table related page)
backspace – Takes you to the oldest page.
A word about users
Many people have difficulty understanding the concept of user management with respect to phpMyAdmin. When a user logs in to phpMyAdmin, that username and password are passed directly to MySQL. PhpMyAdmin does not administer on its own (except allowing to manipulate MySQL user account information); all users must be valid MySQL users.

You May Also Like

About the Author: intermzv

Leave a Reply

Your email address will not be published. Required fields are marked *