Apache Friends Support Forum

I have Windows 7 64 bit, xampp 5.6.3 browser used is Comodo IceDragon. I have three questions to ask and I hope this is in the right category.

1. When exporting the database the template is set as: @Database@ which gives me the following: filename.sql or filename.csv. I would like to have the file exported like this filenameYearMonthDay.sql. I have phpmyadmin installed separately on my other computer, not using xamp at all and I am able to do the following command _DB_-%Y%m%d to get for example: dbbook-20150412.sql. How can I set it in xamp phpmyadmin.

2. Although the database created will not be ever on the internet, it is just a personal file, I would like to set a password on it. I tried through phpmyadmin under users, it was accepted but when I went back into phpmyadmin it did not prompt me with a password. I tried your shell program and it did change but I got an error message from MYSQL saying access was denied when I tried getting back into phpmyadmin. As I could not logon on to phpmyadmin, I uninstalled everything and reinstalled it from scratch. I have read your FAQ document and I have tried those methods but I am not getting a prompt to enter password. I would to enclosed a user account picture to show you the users that are existing but I cannot attache it (dont know how) nor can I post it on the web - do not have server. I log on with http:/127.0.0.1 - I do not know what the others are as I am the only one who uses this computer and logon as administrator.[attachment=]Capture.png[/attachment]

3. I do not see a logout option when I am in phpmyadmin. I just use the X box that my browser has is there a method to close. Also the icon in the notification area when I click on it to "Quit" it gives the following error message "Error: Cannot create File: C:\xampp\xampp-control.ini. Access Denied". Other than that the program works - Apache and MYSQL run, and I can get into phpmyadmin.

Ptah wrote:Iand I hope this is in the right category.

Definately NOT.

Ptah wrote:How can I set it in xamp phpmyadmin.

Whatever you did - PhyMyadmin is PhpMyadmin, it is not "Xampp" or any other thing. Whatever you did, you may do it in each PhpMyadmin installation. Xampp only delivers a pre-installed PhpMyadmin Installation, but it is still only PhpMyadmin.

None of your questions affects Xampp, Xampp is only an abbreveation for a software collection, there is no "Xampp" software. And most difficult: I have no clue, what is meant by "Comodo IceDragon". Couldnt you ask in a Comodo IceDragon Board?? What if you install it on a webserver, which is not configured by Xampp? Same questions, but what is the Xampp Part of it?? I cannot see it.

Ptah wrote:I have phpmyadmin installed separately on my other computer, not using xamp at all and I am able to do the following command _DB_-%Y%m%d to get for example: dbbook-20150412.sql. How can I set it in xamp phpmyadmin.

the same way

Ptah wrote:I tried through phpmyadmin under users, it was accepted but when I went back into phpmyadmin it did not prompt me with a password.
[...]
I tried your shell program and it did change but I got an error message from MYSQL saying access was denied when I tried getting back into phpmyadmin.

sure, because you don't adjust the phpmyadmin config that you want to use the password form instead of config based authentification.

Ptah wrote:I would to enclosed a user account picture to show you the users that are existing but I cannot attache it (dont know how)

This board does not provide any functionallity to attach any files.

Ptah wrote:nor can I post it on the web - do not have server.

On the net there are many one click image hoster. simply search for them.

Ptah wrote:I do not see a logout option when I am in phpmyadmin.

This is the default behavior for config based authentification. phpmyadmin only uses one single user in this mode.
Change the auth_type setting to the correct value and you will be able to use a login form as well as logout your user.

Ptah wrote:when I click on it to "Quit" it gives the following error message "Error: Cannot create File: C:\xampp\xampp-control.ini. Access Denied".

run the control panel with enhanced administrator rights (rightclick -> run as administrator).

Just so that I understand your responses. If I set to save the database with this command _DB_-%Y%m%d will it work. Because I tried it and it did not. It only gave me the name of the database and the extension like: Books.sql which is not what I want. I would prefer: Books20150407.sql. Is there something that I have to change in phpmyadmin.

To change : auth_type value, where do I change in phpmyadmin or on the xampp control panel. What value do I change it to. I appreciate your response. Thank you.

phpMyAdmin => choose the database => Export tab => Export method Custom - display all possible options => File name template @DATABASE@-%Y%m%d%H%I%S => works (tested with XAMPP 5.6.3)

PtahJust wrote:To change : auth_type value, where do I change in phpmyadmin or on the xampp control panel.

In the file \xampp\phpMyAdmin\config.inc.php

PtahJust wrote:What value do I change it to.

Depends. try "cookie" or "http" instead of "config"