Easiest way to do it, if your XAMPP is configured as default:
Go to Applications/XAMPP/xampfiles/phpmyadmin
Copy the config.inc.php file to your desktop.
Open the file and put the following:
- Code: Select all
<?php
/* $Id: config.sample.inc.php,v 2.1.2.2 2006/08/28 08:14:14 nijel Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.cihar.com>.
*/
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'Its a really hot day here in Austin and DW8h22'; /* YOU MUST FILL IN THIS WITH SOME WICKED TEXT, YOU DONT NEED TO REMEMBER IT, JUST CHANGE IT! */
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'YOUR-MY-SQL-PASSWORD-FOR-THE-USER-ABOVE';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
Tip: Change your blowfish phrase and set your correct username/pwd on the file before saving it.
Save the file, copy and paste it from your desktop to the original file path.
It may ask you for your password to paste it, go ahead.
Your php my admin might say now that your config file is unreadable, if it does, go via terminal to the config.inc.php file path and paste this:
- Code: Select all
chmod 644 config.inc.php
Done! No more password thing.