Wednesday 9 March 2016

ACCESS DENIED ERROR IN PHPMYADMIN

If you get an Error #1045 in phpMyAdmin it will look like the image below:
  1. Step 1: Open your MySQL console. ...
  2. Step 2: Enter the Provided Command Lines. ...
  3. Step 3: Open and edit your config.inc.php file located in your local server files. ...
  4. Step 4: Access phpMyAdmin.



This is my config settings in config.inc.php
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

No comments:

Post a Comment