Let me see if I can help. Hopefully the OP hasn't given up yet. By the way, Nobbie, there are plenty of reasons to set a password for PHPMyAdmin, I really do not think the OP should have to explain such a rudimentary need.
First of all, follow the instructions in the How to Guides in the Xampp homepage. This is the page that opens right after Xampp installation. Or you can use the following address on the host computer. localhost/dashboard/docs/reset-mysql-password/html
This will open instructions on how to change the MySQL password in the OSX terminal. It may be a good idea to use root access while executing that command.
After you've done that in terminal, it is possible that you may find errors on the PHPMyAdmin page. Don't panic. Just do the following:
First, change permissions in OSX for the main XAMPP folder so that you have read-write permissions. Do the same for the xamppfiles folder within, and the phpmyadmin folder within that folder as well. Next, change the permissions for config.inc.php, but this time make yourself the owner as well.
If you don't know how to do this, you can just google OSX file permissions. It's not that complicated. All in the "Get Info" window in Finder.NOW, open the config.inc.php file and look for the following lines:
- Code: Select all
$cfg['blowfish_secret'] = 'changexampptosomethinglonger'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */
/**
* Servers configuration
*/
$i = 0;
/**
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'yourpasswordhere';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
You'll notice that I've already made the necessary changes above, so to help you out, it's the following lines you'll want to change:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie';
If the above is left as default, you won't get a login screen, but will simply be logged in invisibly directly to the main PHPMyAdmin page (assuming you've made the other changes).
- Code: Select all
$cfg['Servers'][$i]['password'] = 'yourpasswordhere';
This should be obvious, but it should be the same password you used in Terminal earlier.
- Code: Select all
$cfg['Servers'][$i]['AllowNoPassword'] = false;
This is extremely important since leaving this as true will still (theoretically) allow other users in the default database to be used to login without passwords.
The only other thing I change is the following line just to get rid of the annoying warning message about the secret word being too short that will show up after logging into PHPMyAdmin.
- Code: Select all
$cfg['blowfish_secret'] = 'changexampptosomethinglonger'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */
If I haven't forgotten any important details, this should activate the PHPMyAdmin login screen for PHPMyAdmin to function the way I think you're looking for.
Hopefully this should solve your problem!
If not, let me know. I may have forgotten a detail or two.