CODEWITHSUNDEEP
phpmysqlapachexamppadminer
Aswin G
Aswin G

Reputation: 97

Setting up MySQL managed by Adminer in XAMPP

I'm just having some trouble setting up Adminer in XAMPP. I'm doing something with databases for the first time, so please bear with me if this is an amateur mistake.

So I dropped the adminer.php file into the htdocs folder of XAMPP and started both Apache and MySQL servers from the XAMPP control panel. But when I try to log in after going to localhost/adminer.php, I get the error:

Access denied for user 'abc'@'localhost' (using password: YES)

What should I do to fix this?

Upvotes: 1

Views: 4921

Answers (2)

LuBre
LuBre

Reputation: 1809

Fastest and easiest way

  1. Open phpMyAdmin at http://localhost/phpmyadmin/
  2. Under User Accounts create a new user/password with full privileges
  3. Open Adminer and login with this new user

Upvotes: 0

Jiři Hruška
Jiři Hruška

Reputation: 79

  • Reinstall Xampp
  • Run server, go to localhost into phpMyAdmin.php on webpage
  • Go to User Accounts and click in last Action "Edit privileges"
  • Change password (for example "123456")
  • Go to Xampp folder into PhpMyAdmin and open config.inc.php

Replace - $cfg['Servers'][$i]['auth_type'] = 'config'; - $cfg['Servers'][$i]['password'] = '';

To - $cfg['Servers'][$i]['auth_type'] = 'cookie'; - $cfg['Servers'][$i]['password'] = '123456';

Now

  • Donwload Adminer for MySQL and put it in htdocs.
  • rename Adminer****.php to Adminer.php
  • Open localhost/Adminer.php

Open database

  • localhost
  • root
  • 123456
  • Name of database

Upvotes: 3

Related Questions