phpmyadmin on xampp

I have installed phpmyadmin on xampp. I am accessing from a routable ip. . but I want to put in some login security. Right now it will go straight to my page without any login required. How can I secure it?
Starquest321Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
You installed a second copy of phpMyAdmin?
0
Starquest321Author Commented:
No .. default with xampp
0
Starquest321Author Commented:
I get this error on the mysql:

 Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.

Where is the configuration file?
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

GaryCommented:
Add a password for the root user in MySQL

mysqladmin -u root password new_obscure_password

Open in new window

0
Dave BaldwinFixer of ProblemsCommented:
The configuration file is 'config.inc.php' in C:\xampp\phpmyadmin .
0
Starquest321Author Commented:
This is xampp ..  .how can I do this? It's not like centos or something. I am running this on a windows machine.
0
GaryCommented:
You run it from a command prompt, you may need to navigate to the MySQL folder which on XAMPP will be
C:\xampp\mysql\bin
0
Dave BaldwinFixer of ProblemsCommented:
MySQL is still the same on Windows and Linux (and Mac too).  With XAMPP, you may have to go to the MySQL directory to run the 'mysql' programs.  Look in C:\xampp\mysql\bin for all the usual utility programs.  With XAMPP, they are not normally included in the path so you have to be in the directory (or use the complete long path name) to run them.
0
Starquest321Author Commented:
Quick question: is XAMPP on a strong machine production grade? Is it just as secure? Can I run :: maintain a full site on it?
0
GaryCommented:
No it is not secure, it's more commonly used for local development.
http://robsnotebook.com/xampp-security-hardening

Also make sure you firewall is running and has no open ports bar what is needed e.g. 80,443 etc
0
Starquest321Author Commented:
But if I can secure it . . can I use it for production grade: Meaning website, etc. etc. ?
0
GaryCommented:
Yes, XAMPP is just a wrapper GUI/installer for Apache, MySQL etc - XAMPP itself does nothing else.
0
Starquest321Author Commented:
So this is the SAME version of APACHE :: MYSQL that I would get with a CENTOS install?
0
GaryCommented:
Yes, though it is usually a slighly lower version of whatever the current versions are.
0
Dave BaldwinFixer of ProblemsCommented:
You can 'secure' it yourself... but nobody is going to support you in doing it.  XAMPP and WAMP both tell you upfront not to do that.  Security is a full time job at hosting companies.  To be really 'secure', you have to keep up with all the security concerns for ALL of the programs on the server which include the OS and networking and firewall (Windows in this case), Apache, PHP, MySQL, Perl, FTP server, SSH?, and any mail server you choose to use.  Larger hosting companies even have full-time professional programmers and they compile their own versions of those program with enhanced security features ( and without known security problems).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
It's the same 'version' but it's compiled with a Windows C compiler, not a Linux compiler.  You can not take the XAMPP version and run it on CentOS.  Every distribution including XAMPP and CentOS also have their own ways of doing things.  Each of the programs are compiled for the system they are going to run on.  You can't take Linux versions and copy them between systems because they often put things in different places.
0
Starquest321Author Commented:
so final questions: The database are movable. . . meaning a database on a xampp instance and transport into centos, right?
0
GaryCommented:
Yes
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apache Web Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.