Stop phpmyadmin from asking me uid and pwd.

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Stop phpmyadmin from asking me uid and pwd.

Postby MacPaq » 30. December 2012 23:04

Hi, I have XAMPP 1.7.3 installed on my Mac.
Overall I really like XAMPP, and I only use it for site development and occasionally to demo work progress to client.
So a minimum security is sufficient. I have set up security for XAMPP, but what really annoys me is phpMyAdmin keeps asking my for my credentials when I need to check my DB. There must be somewhere in the config file I can make it stop for good, but what and where do I edit it?

Thanks in advance
User avatar
MacPaq
 
Posts: 12
Joined: 04. December 2007 14:50

Re: Stop phpmyadmin from asking me uid and pwd.

Postby antoniomax » 14. February 2013 00:54

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.
antoniomax
 
Posts: 11
Joined: 12. July 2008 09:15


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 28 guests