phpMyAdmin 


phpmyadmin.png apg

The

phpMyAdmin

is written in

PHP - Hypertext Preprocessor

and its purpose is to manage the

Databases

created by the

MySQL Community Server



To access

MySQL Commity Server

using

phpMyAdmin

you need to activate

Apache Server on port 80

and

MySQL Commity Server

Remembering that the

phpMyAdmin

system requires the

PHP language

already installed on the system.


 ATENTION 


ONLY ONE INSTANCE OF EACH SERVER
MUST BE ACTIVE AT THE SAME TIME
AT SAME PORT.




Desktop -> Server

Double-click

on each of the shortcuts:

httpd.exe - Shortcut

and

mysqld.exe - Shortcut

to activate the

Apache Server on port 80

and

MySQL community Server

respectively.

phpm00.png apb


Desktop -> Server

Both servers must remain minimized on the

Taskbar

phpm01.png apb


localhost/phpmy

Open your favorite browser and enter the URL:

localhost/phpmy

phpm02.png apb

phpMyAdmin

Welcome to phpMyAdmin

phpm03.png apb

root

Enter the

Username: root

then press the

Go button


Due to our current configuration, at the moment, it is not necessary to enter any

Password

phpm04.png apb


phpMyAdmin is opened

phpMyAdmin

phpm05.png apb


phpMyAdmin

is almost ready to be used, however, some important things are missing to be implemented.


First thing to implement

If the following message appears at the bottom of this page:

phpm06.png apb

Click on the indicated link:

Find out why


First thing to implement

Configuration of pmadb... not OK
General relation features Disabled

phpm07.png apb

Click on the indicated link:

Create


First thing to implement

After completing the command...

phpm08.png apb

... a new

Database

is added to the list:

phpmyadmin


Second thing to implement

Select the

User accounts

tab and then select the user:

root

phpm09.png apb

Click on the indicated link:

Edit privileges


Second thing to implement

Within

User accounts

select

Change password

phpm10.png apb


Second thing to implement

You have the following methods of using HASH to generate the password:

Native MySQL authentication,
SHA256 password authentication
and
Caching sha2 authentication.


Using, for simplicity, the Native MySQL authentication method, leads us to two possibilities:

1. Click on the Generate button to generate
    a password for the system.

    Before pressing the Go button,

    DO NOT FORGET
    TO NOTE THE GENERATED PASSWORD.

2. Use your favorite password.
    In this case, you initially type the Password
    in the Enter box and retype it
    in the Re-type box, before clicking
    the Go button.

phpm11.png apb

Any of these possibilities serve the same purpose.


Second thing to implement

The indicated warning will then be displayed.

phpm12.png apb


Going to phpMyAdmin Home

Click on

house.png apb

icon.

phpm13.png apb


Home of phpMyAdmin

Information about:

Database server,
Web server
and
phpMyAdmin.

phpm14.png apb


Logging out the phpMyAdmin



Click on

out.png apb

icon.

phpm15.png apb


Logging out the phpMyAdmin


Below the new configuration of the

config.inc.php

to allow the password requirement to connect

phpMyAdmin

and

MySQL Community Server

For security reasons, you should replace the old

H:/WEB/public_html/phpmy/config.inc.php

with the one described below.


<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 *
 * All directives are explained in documentation in the doc/ folder
 * or at <https://docs.phpmyadmin.net/>.
 *
 * @package PhpMyAdmin
 */

/**
 * This is needed for cookie based authentication to encrypt password in
 * cookie. Needs to be 32 chars long.
 */
$cfg['blowfish_secret'] = 'BBCCDDFFAEAFDADEAAAADDDDCCCCECDCEFADAAEED4EEAA'; 
/* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/**
 * Servers configuration
 */
$i = 0;

/**
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* Changed to false to require password access */


/**
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma__relation';
// $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
// $cfg['Servers'][$i]['history'] = 'pma__history';
// $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
// $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
// $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
// $cfg['Servers'][$i]['recent'] = 'pma__recent';
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['users'] = 'pma__users';
// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
// $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
// $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

/**
 * End of servers configuration
 */

/**
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

/**
 * Whether to display icons or text or both icons and text in table row
 * action segment. Value can be either of 'icons', 'text' or 'both'.
 * default = 'both'
 */
//$cfg['RowActionType'] = 'icons';

/**
 * Defines whether a user should be displayed a "show all (records)"
 * button in browse mode or not.
 * default = false
 */
//$cfg['ShowAll'] = true;

/**
 * Number of rows displayed when browsing a result set. If the result
 * set contains more rows, "Previous" and "Next".
 * Possible values: 25, 50, 100, 250, 500
 * default = 25
 */
//$cfg['MaxRows'] = 50;

/**
 * Disallow editing of binary fields
 * valid values are:
 *   false    allow editing
 *   'blob'   allow editing except for BLOB fields
 *   'noblob' disallow editing except for BLOB fields
 *   'all'    disallow editing
 * default = 'blob'
 */
//$cfg['ProtectBinary'] = false;

/**
 * Default language to use, if not browser-defined or user-defined
 * (you find all languages in the locale folder)
 * uncomment the desired line:
 * default = 'en'
 */
// $cfg['DefaultLang'] = 'pt_BR';
//$cfg['DefaultLang'] = 'de';

/**
 * How many columns should be used for table display of a database?
 * (a value larger than 1 results in some information being hidden)
 * default = 1
 */
//$cfg['PropertiesNumColumns'] = 2;

/**
 * Set to true if you want DB-based query history.If false, this utilizes
 * JS-routines to display query history (lost by window close)
 *
 * This requires configuration storage enabled, see above.
 * default = false
 */
//$cfg['QueryHistoryDB'] = true;

/**
 * When using DB-based query history, how many entries should be kept?
 * default = 25
 */
//$cfg['QueryHistoryMax'] = 100;

/**
 * Whether or not to query the user before sending the error report to
 * the phpMyAdmin team when a JavaScript error occurs
 *
 * Available options
 * ('ask' | 'always' | 'never')
 * default = 'ask'
 */
//$cfg['SendErrorReports'] = 'always';

/**
 * You can find more configuration options in the documentation
 * in the doc/ folder or at <https://docs.phpmyadmin.net/>.
 */


The

Apache Server on port 80

and

PHP 7.4.XX

and

MySQL on port 3306

is already installed and configured.


Next Step:

Upgrading Apache+PHP+MySQL as is