1

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?

Aswin G
  • 97
  • 2
  • 8
  • https://sourceforge.net/p/adminer/discussion/960417/thread/2bf54b69/ Permission of the Account in the mysql – KikiTheOne Oct 12 '16 at 09:35
  • 1
    I think your username or password is wrong. Default parameters of XAMPP are ''root" and "" (empty string). Also I recommend MySQL Workbench for database operations. http://www.mysql.com/products/workbench/ – Hakan SONMEZ Oct 12 '16 at 09:40
  • How do I change it? Trying to log in by leaving the password field empty gives me 'invalid database' – Aswin G Oct 12 '16 at 10:02

1 Answers1

3
  • 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
Jiři Hruška
  • 79
  • 7