1. MySQL Commands Login# mysql -u root -p
2. Create User # CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘12345678’;
3. Add Privileges # GRANT ALL PRIVILEGES ON . TO ‘user’@’localhost’;
4. Change Password# ALTER USER ‘user’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘12345678’;

download phpmyadmin https://www.phpmyadmin.net/downloads/

save file config.inc.php    in phpmyadmin  folder

code :

<?php
/**
* Generated configuration file
* Generated by: phpMyAdmin 5.2.0 setup script
* Date: Tue, 10 Jan 2023 07:41:49 +0000
*/

/* Servers configuration */
$i = 0;

/* Server: 127.0.0.1 [1] */
$i++;
$cfg[‘Servers’][$i][‘verbose’] = ”;
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
$cfg[‘Servers’][$i][‘user’] = ‘user’;
$cfg[‘Servers’][$i][‘password’] = ‘12345678’;

/* End of servers configuration */

$cfg[‘blowfish_secret’] = ‘VZP.$U_vB#G\\;>q-r]qY=9<&6(\\GB1S1’;
$cfg[‘DefaultLang’] = ‘en’;
$cfg[‘ServerDefault’] = 1;
$cfg[‘UploadDir’] = ”;
$cfg[‘SaveDir’] = ”;