Dengan menginstall XAMPP maka tidak perlu lagi melakukan instalasi dan konfigurasi web server Apache, PHP dan MySQL secara manual. XAMPP akan menginstalasi dan mengkonfigurasikannya secara otomatis untuk Anda. Pada XAMPP 1.7.3 terdiri atas beberapa paket antara lain: Apache 2.2.14 (IPv6 enabled) + OpenSSL 0.9.8l; MySQL 5.1.41 + PBXT engine. XAMPP adalah aplikasi yang membantu pengguna dengan mudah menginstal distribusi Apache yang berisi MySQL, PHP dan Perl. XAMPP dapat di install pada beberapa sistem operasi baik windows, linux dan juga MacOS. XAMPP for Mac OS X adalah sebuah paket aplikasi yang penting bagi setiap pengembang web. Di dalamnya Anda akan menemukan peladen Apache, bahasa pemrograman PHP dan PERL serta sistem basis data MySQL. Tanpa diragukan lagi, salah satu dari fitur utama XAMPP for Mac OS X adalah instalasinya yang sederhana.
Anda dapat membuat pintasan 'xampp-control.exe' di desktop Anda (klik kanan pada 'xampp-control.exe' Kirim ke - Desktop) dan ganti nama pintasan untuk ex. 'xampp 5.6.31' dan 'xampp 7.1.8'. Mulai panel kontrol XAMPP dengan klik dua kali pada 'xampp-control.exe' atau pintasan yang dibuat sebelumnya dan mulai server Apache dan MySQL.
We all know the purpose of installing XAMPP on a computer is to achieve a local platform to develop and test a web app locally before making it live. But if there’s a problem installing XAMPP MySQL then you may seek professional help and that’s where precisely this blog post will help you.
XAMPP is a software packet which contains four key components i.e. X stands for cross-platform compatibility, A (Apache web server), M (MySQL database), P(PHP), P (Perl). It has been designed to provide you a smooth installation experience to create a local web server for development and testing purpose. However, working on a website either on a local computer or hosted, you would need a database. Don’t worry, you don’t have to be MySQL expert to create a database with XAMPP. You can use phpMyAdmin graphical user interface for MySQL.
In this post, you will learn how XAMPP MySQL installation and configuration takes place. However, in my previous posts on how to install XAMPP and how to install WAMP, I’ve fully explained the role of MYSQL. But in this post, I’ll specifically talk about MySQL and Apache in reference to XAMPP.
Xampp 1.7.3 Download
Download and Install: XAMPP MySQL Apache and PHP/Pearl
First, you need to download and install XAMPP installer on your computer. This way you’ll get a dedicated control panel to manage all the components. Whilst installing XAMPP you’ll see an option to select whether you wish to run MySQL and Apache as services. If you select the option, then MySQL and Apache will start at system boot-up with the database web management tool phpMyAdmin user interface to manage XAMPP MySQL.
What is MySQL?
MySQL is an open source relational database management system (RDBMS) that relies on SQL (structured query language). Most of the web-based applications use RDBMS for its development. Basically, MySQL helps you structure your data, present the information in an organized manner, edit, delete, update, or retrieve data whenever required.
Any content management system (CMS) you use to create your website be it WordPress, Drupal, Magento, PrestaShop, etc. you would need MySQL to store and retrieve its data. All type of data like post content, post type, user profiles, tables, etc. is accessible via MySQL only. Mostly web servers which provide you one-click installation have already installed MySQL so that you don’t have to do it externally.
XAMPP MySQL as a package
XAMPP is a cross-platform compatible Apache distribution. Likewise, MySQL perfectly works on multiple operating systems and it can easily integrate with PHP. On XAMPP MySQL works as a database component which is required to run a database-enabled website and servers. On the control panel of XAMPP MySql and Apache need to be started first in order to run the website on the local server. As shown in the screenshot below. And when you see their status turned into green, that means it has been started correctly.
XAMPP MySQL and phpMyAdmin
If you are going to have a WordPress website the best practice is to develop and test it locally before making it live. However, not only a WordPress website, rather any cms say Joomla, Drupal, PrestaShop, etc. you should test a website in a local environment before presenting it to live users.
In order to create a database or tables for the website, you need to log in to phpMyAdmin user interface. Click the Admin button from the XAMPP to run phpMyAdmin and the interface will look like the one shown below. Here, go to the ‘phpmyadmin’ click on the ‘New’ and then name the database. And finally, click on the ‘Create’ button to finish the process.
Conclusion
So you can see how important role MySQL plays in the web development realm. In the layman language, we can say MySQL XAMP is like the backbone for a project. I’ll tell you why!! A project needs to be tested thoroughly to be successful. So, for this purpose, you need to have a secure and fully equipped platform. And XAMPP provides the required platform loaded with requisite components.
As you are are going to design a website and you are familiar with your CMS may be it is WordPress or Joomla, and you have also created the local development environment with XAMPP and MySQL with Apache Web Server. Now you need a beautiful website or theme. And to craft a beautiful website you need a powerful website builder. There are many WordPress Theme Builders available now these days but I’ll recommend TemplateToaster, it works locally on your Windows PC to design website of your choice. Produce your stunning website with this website builder and kick start your website in no time at all.
These instructions are for XAMPP 1.7.3 running on Windows XP.
They should be similar for other configuration combinations, but no guarantee is made.
These instructions should also work for an Apache Server install that is not part of a XAMPP install (specific details regarding file locations and restarting of the Apache Server will differ).
NOTE: XAMPP 1.7.4 and XAMPP 1.7.7 display misleading port information in the XAMPP Control Panel.
Regardless of which port you specify Apache to listen to, the XAMPP Control Panel will always display:
Masalah Mysql Di Xampp 1.7.3 For Mac Os
Apache started [Port 80]
This is WRONG!!!! This is a HARDCODED string in XAMPP 1.7.4 and 1.7.7. It does not reflect the actual port Apache is listening to.
Yet another reason why you should not be using XAMPP 1.7.4 or 1.7.7.
By default, Apache Server listens on port 80, but this can be changed.
Why Change the Port?
Perhaps certain ports are blocked by your network admin or ISP (although, I would not recommend running XAMPP as a publicly accessible server).
Perhaps port 80 is already being used by some other application (like IIS) and you don’t want to or are not allowed to shut it down or change it.
Apache Server is not starting and you are using XAMPP 1.7.4 (I recommend XAMPP 1.7.3). XAMPP 1.7.4 removed a useful port debugging tool, so changing the Apache Server port is one way of checking to see if you have a port conflict – change the port and if Apache Server starts working, then you know some other application is using port 80. You should try several ports, just in case you are lucky and manage to pick ports used by other applications. Some ports to try are 2375, 4173, 5107, 9260, 20010 – these ports, among others, are all listed as unassigned (but that doesn’t mean someone else isn’t using them).
How to Change the Port
Edit the httpd.conf file to change the port Apache listens on.
(1) Locate the file httpd.conf. This file should be found in C:xamppapacheconf (or whichever directory you installed XAMPP in – mine is on my D-drive because that is where I installed XAMPP).
(2) Open the file using a text editor or programmer’s editor (I use notepad++). DO NOT use a word processor (like Word) to open the file, it will badly mess it up.
(3a) Locate the line that says Listen 80. It is line #47 in the XAMPP 1.7.3 install.
(3b) Change the port number (80) to a different number (for this tutorial, I changed it to 1234).
(3c) Save the file.
(4) Restart the Apache Server to have the change take effect. Do this by clicking on the Stop button on the XAMPP control panel and then clicking on the Start button. (You could also just reboot the computer, but that is overkill).
Masalah Mysql Di Xampp 1.7.3 For Mac Installer
When you connect to the Apache Server, you will have to append the port number to the URL. Previously where you typed localhost, you will now have to type localhost:1234 (or whatever your new port number is):
Masalah Mysql Di Xampp 1.7.3 For Mac Download
Note: in Microsoft Internet Explorer 8 (IE8), it is necessary to prepend the prefix http:// before localhost: localhost:1234 will not work, it must be http://localhost:1234.
I did not observe this with Firefox 4.0 – entering localhost:1234 worked just fine (the browser was able to resolve the address as http://localhost:1234).
Masalah Mysql Di Xampp 1.7.3 For Mac Pro
Second note: this is not a bug in IE8 – as a convenience, browsers automatically try to fixup URLs for you. Technically, you ARE required to type http:// before every URL you type in.