Page 1 of 1
XAMPP for your MySQL
Posted: Tue Jul 08, 2014 5:34 am
by wyll001
XAMPP is a great tool for MySQL,
it is free,
no sign up needed,
have a build-in database editor (that's right, no need for navicat),
have Apache, FileZila and Mercury services as well.
you should try now
https://www.apachefriends.org/download.html
Re: XAMPP for your MySQL
Posted: Tue Jul 08, 2014 6:02 am
by bluekirby0
For those who don't know, XAMPP is a full web server distribution that includes a lot of things you don't need to just run DSP so this is more for people who want to build a full community around their servers.
Re: XAMPP for your MySQL
Posted: Tue Jul 08, 2014 1:54 pm
by atom0s
wyll001 wrote:XAMPP is a great tool for MySQL,
it is free,
no sign up needed,
have a build-in database editor (that's right, no need for navicat),
have Apache, FileZila and Mercury services as well.
you should try now
https://www.apachefriends.org/download.html
If your standpoint for this is just to have a database editor (I assume phpMyAdmin) that is a bit overkill and not really needed. A stand-alone application such as Navicat (or you know.. MySQL Workbench from the creators of MySQL itself entirely free) handles things just fine, with no need for all kinds of web service stuff.
If you do need a web server, I would recommend nginx personally.
Re: XAMPP for your MySQL
Posted: Tue Jul 08, 2014 5:28 pm
by kloe
Here's a warning to anyone wanting to try out XAMPP straight from their FAQ:
Is XAMPP production ready?
XAMPP is not meant for production use but only for development environments. The way XAMPP is configured is to be open as possible to allow the developer anything he/she wants. For development environments this is great but in a production environment it could be fatal.
Here a list of missing security in XAMPP:
The MySQL administrator (root) has no password.
The MySQL daemon is accessible via network.
ProFTPD uses the password "lampp" for user "daemon".
PhpMyAdmin is accessible via network.
The XAMPP demopage is accessible via network.
The default users of Mercury and FileZilla are known.
All points can be a huge security risk. Especially if XAMPP is accessible via network and people outside your LAN. It can also help to use a firewall or a (NAT) router. In case of a router or firewall, your PC is normally not accessible via network. It is up to you to fix these problems. As a small help there is the "XAMPP Security console".
Please secure XAMPP before publishing anything online. A firewall or an external router are only sufficient for low levels of security. For slightly more security, you can run the "XAMPP Security console" and assign passwords.
If you want have your XAMPP accessible from the internet, you should go to the following URI which can fix some problems:
http://localhost/security/
With the security console you can set a password for the MySQL user "root" and phpMyAdmin. You can also enable a authentication for the XAMPP demopages.
This web based tool does not fix any additional security issues! Especially the FileZilla FTP server and the Mercury mail server you must secure yourself.