Starquest321
asked on
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?
Dave Baldwin
You installed a second copy of phpMyAdmin?
ASKER
No .. default with xampp
ASKER
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?
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?
Add a password for the root user in MySQL
mysqladmin -u root password new_obscure_password
The configuration file is 'config.inc.php' in C:\xampp\phpmyadmin .
ASKER
This is xampp .. .how can I do this? It's not like centos or something. I am running this on a windows machine.
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
C:\xampp\mysql\bin
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.
ASKER
Quick question: is XAMPP on a strong machine production grade? Is it just as secure? Can I run :: maintain a full site on it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But if I can secure it . . can I use it for production grade: Meaning website, etc. etc. ?
Yes, XAMPP is just a wrapper GUI/installer for Apache, MySQL etc - XAMPP itself does nothing else.
ASKER
So this is the SAME version of APACHE :: MYSQL that I would get with a CENTOS install?
Yes, though it is usually a slighly lower version of whatever the current versions are.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
so final questions: The database are movable. . . meaning a database on a xampp instance and transport into centos, right?
Yes