Thursday, January 8, 2015

How to login without password in phpMyAdmin

How to login without password in phpMyAdmin 



paswordless root login for MySQL. phpMyAdmin however is by default set to not allow that.

If disabled, you'll get the following error when trying to log in without entering the password;


location



/etc/phpmyadmin/config.inc.php


 To enable the option, uncomment or add the following line;
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

there is two times this line  remove comment 
 

The line above need to be added twice; once within within the
if (!empty($dbname)) 
{ statement, and another one outside of it
 (probably towards the end of the configuration file). 

No comments:

Post a Comment

How to Host a Laravel Project on Hostinger’s hPanel: A Step-by-Step Guide

How to Host a Laravel Project on Hostinger’s hPanel: A Step-by-Step Guide If you're looking to host a Laravel project on Hostinger’s hPa...