phpmyadmin Question posted in
The official documentation can be found here.

Not able to run mysql as admin in xampp – Phpmyadmin

I am unable to run mysql as admin.

In the xampp command window, I tried login in as root it was successful but not able to run MySQL as admin.

Even in the control panel, there are no such errors displayed everything seemed perfect but while running MySQL as admin it is showing invalid settings

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    my config.inc.php was

    $cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root'; 
$cfg['Servers'][$i]['password'] = ''; 
$cfg['Servers'][$i]['host'] = '127.0.0.1'; 
$cfg['Servers'][$i]['connect_type'] = 'cookie';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

    I changed it to

    $cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

    And this resolves my issue


  2. 0

    Did you install and run phpmyadmin ? (if you can run phpmyadmin, then login as root and your password and you can do all administrative works such as creating user / database, etc.)

    In my understanding XAMPP comes with phpmyadmin by default. you may use the following standard link:

    http://localhost/phpmyadmin

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search