Apache Friends Support Forum

Hello all, I have just started using Mysql and Xampp, and I configured my xampp with security passwords and users on my phpmyadmin, and i have an installer for my app that also installs xampp, but i don't know how to restore the previous xampp configs, any help on these? BTW i used the portable editions but they lack certain features and have bugs... i exported the 5.6.14 database and imported it in portable edition and i always give me an error, but other 5.6.14 on other machine works fine, and wondering how to backup and restore xampp settings...............

Hi DFlow,

There are no "global" XAMPP settings you could export or import. There are Apache configs, MySQL configs, PHP configs, etc.
Please be more specific what you exactly want to backup and restore.

You are talking about MySQL users, so maybe you want to export and import mysql users and privileges?
There are multiple ways to dump this information:
http://stackoverflow.com/a/9410698
http://dba.stackexchange.com/a/95933
http://www.uptimemadeeasy.com/linux/mys ... er-server/

Simply google for "export mysql user privileges". I am sure you will even find other solutions for this.

DFlow wrote:BTW i used the portable editions but they lack certain features and have bugs.

Which features are you missing? And which bugs did you find?

DFlow wrote:and imported it in portable edition and i always give me an error,

Which error? We need the full error message.

best wishes,
Altrea

Thank you for your quick response. After installing i am looking at [img]C:\Users\Dash-Ulziit\Desktop\Untitled.png[/img] and no option to secure my phpmyadmin.......... and anyone can access it............ i want to secure the phpmyadmin with a password and export that user and privileges. But when i try to add password to existing localhost, it gives me this [img]C:\Users\Dash-Ulziit\Desktop\Untitled2.png[/img], and cannot login at all.............. what am i doing wrong here? and can you please teach me how to add a picture?? hehehehee

DFlow wrote:Thank you for your quick response. After installing i am looking at [img]C:\Users\Dash-Ulziit\Desktop\Untitled.png[/img]

You cannot show local pictures in the internet!

DFlow wrote:and no option to secure my phpmyadmin

PhMyAdmin is only a GUI frontend for MySQL, you cannot "secure" phpmyadmin, you only can secure MySQL. But it is safe anyway.

DFlow wrote:.......... and anyone can access it............

I dont think so. I also have a couple of Xampp installations and use them "out of the box". Please access my MySQL Database, you may destroy everything you find. Tell me, when you are ready.

Ok, then how can i show images? and in previous versions, i could give passwords in the "hostname"page and when i access the "hostname"/phpmyadmin, it would ask username and password, but now, when i type "hostname"/phpmyadmin from any machine, i would access it freely, i want that feature from the previous versions............

In current XAMPP versions phpMyAdmin is only requestable from the computer XAMPP is installed on.

Ok so, that is very nice, and if i lock out the root users, no one can access the phpmyadmin from local computer or remote and databases can only be access via codes, right? then That would make it very much reliable, But if i extract the user files, and copy it after i install new instance, will it still work? but i cannot find mysql.db, mysql.tables_priv and mysql.columns_priv anywhere in the xampp folder...........

Ok, Can you please give my full instruction on how to backup the users files and restore them, if possible, i like a way to just copy and paste user files after installation.............