{"id":13798,"date":"2020-05-20T06:49:57","date_gmt":"2020-05-20T06:49:57","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=13798"},"modified":"2021-11-08T09:36:44","modified_gmt":"2021-11-08T09:36:44","slug":"how-to-fix-an-error-of-phpmyadmin-access-denied-in-xamp-mysql","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-fix-an-error-of-phpmyadmin-access-denied-in-xamp-mysql\/","title":{"rendered":"How to fix an error of PhpMyAdmin access denied in xamp mySql."},"content":{"rendered":"\n

Error resolving of PhpMyAdmin access denied<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For most first time install, accessing http:\/\/localhost\/PhpMyAdmin will directly take us to the PhpMyAdmin web interface without asking for password or anything because by default there is no password set. But when you install it second time you can face an error like this while accessing PhpMyAdmin.Due to that previous default loaclhost port number is not valid now.<\/p>\n\n\n\n

What should be done! Let’s see in below with some easy steps.<\/p>\n\n\n\n

1.<\/strong> So , you have to open XAMPP Control Panel ->Click MySql Config->Click my.ini<\/p>\n\n\n\n

\"\"
XAMPP control panal fig. 1<\/strong><\/figcaption><\/figure>\n\n\n\n

It will open in notepad as shown in figure.<\/p>\n\n\n\n

\"\"
my.ini fig.2<\/strong><\/figcaption><\/figure>\n\n\n\n

2.<\/strong> You have to write this line skip-grant-tables<\/strong> after [mysqld].<\/p>\n\n\n\n

3.<\/strong>Open xamp folder ->PhpMyAdmin .You will see config.inc.php file in phpMyAdmin folder, just open it with notepad++<\/p>\n\n\n\n

\"\"
MyPhpAdmin folder fig.3<\/strong><\/figcaption><\/figure>\n\n\n\n

$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; This is default port number.<\/p>\n\n\n\n

\"\"
config.inc.php fig.4<\/strong><\/figcaption><\/figure>\n\n\n\n

4.<\/strong> Resolve this issue by manually editing in the file “config.inc.php” located at “C:\\xampp\\phpMyAdmin”. Write “localhost:3307” within $cfg[‘Servers’][$i][‘host’] = ‘localhost:3307′<\/strong>; as shown given picture.<\/p>\n\n\n\n

\"\"
config.inc.php fig.5<\/strong><\/figcaption><\/figure>\n\n\n\n

5. <\/strong>Save this changes. You can find port number as follows: Open XAMP->config->service port setting->mySql.<\/p>\n\n\n\n

\"\"
ServerSettings fig.6<\/strong><\/figcaption><\/figure>\n\n\n\n

Now , you can access MyPhpAdmin.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Thanks.<\/p>\n\n\n