15

I downloaded the most recent version of XAMPP (v.1.7.7) and decided start a database. When I opened phpMyAdmin, it alerts me there is a new version of phpMyAdmin available. I downloaded it from online, and I deleted the old version of phpMyAdmin and replaced it with the current version (v.3.5.1). I opened it up and it came up with a log-in screen. I entered in "root" without a password, but it alerts me I need one. I don't know any password nor I know any alternative log-ins. How would I log-in to enter phpMyAdmin?

slippery
  • 447
  • 3
  • 5
  • 15

3 Answers3

24

Enabling login without a password, to make it work exactly as before

You'll need to change your configuration file. Open up your XAMPP installation directory, browse to the folder phpmyadmin, and look for a file called config.inc.php. If there isn't one already, you'll first need to copy config.sample.inc.php to config.inc.php. Then, just open config.inc.php and find this line:

$cfg['Servers'][$i]['AllowNoPassword'] = false;

Change it to:

$cfg['Servers'][$i]['AllowNoPassword'] = true;

Alternatively, just add a password

Open a command prompt and type this, followed by Enter:

mysqladmin -u root -p pass

When it asks you for the current password, just press Enter again. Then set the new password, and log in to phpMyAdmin using that.

Ry-
  • 218,210
  • 55
  • 464
  • 476
19

Default is:

Username: root

Password: (just leave it blank)

The Password is set to 'password' in some versions.

CHarris
  • 2,693
  • 8
  • 45
  • 71
0

In new versions note that you have to change your code to like this:

mysqli_connect($mysql_hostname, $mysql_username, $mysql_password, $mysql_dbname);

And for more look to this:
Fatal error: Uncaught Error: Call to undefined function mysql_connect()

Noel Widmer
  • 4,444
  • 9
  • 45
  • 69
Radwan Al Hourani
  • 31
  • 8