All Latest Earning Stuff: XAMPP

Showing posts with label XAMPP. Show all posts

How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?

How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?

In this post we shall see How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default? Read more »

April 07, 2018

How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?

<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: justify;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyUjcQzxiSUZh0YOjQh4UAMUTmLdlPn4gMPIarh0IkMdo2JfhYikzRMG2kxRk4AFCTlIUxwi0kiNOaKeIJbBn6OWYYlRA9wq5DMlL0V3EAth3Kt1paUR6wRzSdCJQ4-qiS3bC9WOQaoPA/s1600/xampp-apache-http-port-80-8080.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default" border="0" data-original-height="538" data-original-width="833" height="412" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyUjcQzxiSUZh0YOjQh4UAMUTmLdlPn4gMPIarh0IkMdo2JfhYikzRMG2kxRk4AFCTlIUxwi0kiNOaKeIJbBn6OWYYlRA9wq5DMlL0V3EAth3Kt1paUR6wRzSdCJQ4-qiS3bC9WOQaoPA/s640/xampp-apache-http-port-80-8080.png" title="How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default" width="640" /></a></div><br />In this post we shall see How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default? XAMPP Control Panel tries to open the Apache and phpMyAdmin pages at http://localhost, which is using http port 80. After changing Apache http port from 80 to 8080, Apache and phpMyAdmin can no longer be opened on port 80. So by clicking on "Admin" button on the XAMPP Control Panel, Apache and phpMyAdmin pages will not open. Instead we will see that the site cannot be reached.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7a8P8UCSM5ICsQfesz9kVM7UXZ1ycftSgotOqeGVkR2L0byQd6D30UPt0Z146lthGkqF36T7eZY49hOtOU25-Nw2xDcn3HYkLRyxWveJxqFt9TtjosXIpcsA2oPn7iShlp72klaEhpxM/s1600/xampp-control-panel-admin-apache-http-port-80-8080.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="after-changing-port-8080-apache-page-not-opening-xampp" border="0" data-original-height="795" data-original-width="1467" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7a8P8UCSM5ICsQfesz9kVM7UXZ1ycftSgotOqeGVkR2L0byQd6D30UPt0Z146lthGkqF36T7eZY49hOtOU25-Nw2xDcn3HYkLRyxWveJxqFt9TtjosXIpcsA2oPn7iShlp72klaEhpxM/s640/xampp-control-panel-admin-apache-http-port-80-8080.png" title="after-changing-port-8080-apache-page-not-opening-xampp" width="640" /></a></div><br />In such a case, we need to manually add port 8080 after localhost in the URL in the browser address bar. Or, we can also configure XAMPP to open Apache and phpMyAdmin to open on port 8080 by default when the Admin button on XAMPP Control Panel is clicked.<br /><br /><b><span style="font-size: large;">How to change Apache http port from 80 to 8080 in XAMPP?</span></b><br />Watch this short video for steps. Or refer to <a href="http://techubber.blogspot.com/2014/08/how-to-change-apache-server-localhost-port-80-to-8080-wamp.html">this article</a> for the steps.<br /><br /><iframe allow="autoplay; encrypted-media" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/MaFB6od53Aw" width="560"></iframe> <br /><span style="font-size: large;"><b>How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?</b></span><br /><br />As mentioned above, XAMPP Control Panel tries to open the Apache and phpMyAdmin pages at  http://localhost, which is using http port 80. After changing Apache  http port from 80 to 8080, Apache and phpMyAdmin can no longer be opened  on port 80.<br /><br />In such a case, we can also  configure XAMPP to open Apache and phpMyAdmin to open on port 8080 by  default when the Admin button on XAMPP Control Panel is clicked.<br /><br /><b>Watch this video how to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default:</b></div><div style="text-align: justify;"><iframe allow="autoplay; encrypted-media" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/ZKoku6AGxbA" width="560"></iframe></div><br /><b><span style="font-size: large;">Steps to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default</span></b><br /><ul style="text-align: left;"><li> Stop services from XAMPP Control Panel</li><li>Click on CONFIG on the XAMPP Control Panel</li><li>Click on SERVICE AND PORT SETTINGS</li><li>On the Apache tab, change the port from 80 to 8080</li><li>Click save</li><li>Click save</li><li>Start Apache</li><li>Start Apache and MySQL Services from XAMPP Control Panel</li><li>Click on Admin button on XAMPP Control Panel corresponsing to Apache and phpMyAdmin</li><li>Apache and phpMyAdmin pages should open automatically using the port 8080</li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMcr2kakic-tRuGMEYdSQfT7vmyZqHQG46jtObZs1GsIAqaQbYNnh6-ZAZGO0NGdOtlRb2OEw2Y0XtnTt01Sj7dbllJpyntE0YCKWIjCZH7XnHon0XSxxmbBsd6Tn3U6lZaUcE3f-aNhM/s1600/xampp-control-panel-change-apache-port-80-8080-userinterface.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="xampp-control-panel-change-apache-port-80-8080-userinterface" border="0" data-original-height="799" data-original-width="1299" height="392" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMcr2kakic-tRuGMEYdSQfT7vmyZqHQG46jtObZs1GsIAqaQbYNnh6-ZAZGO0NGdOtlRb2OEw2Y0XtnTt01Sj7dbllJpyntE0YCKWIjCZH7XnHon0XSxxmbBsd6Tn3U6lZaUcE3f-aNhM/s640/xampp-control-panel-change-apache-port-80-8080-userinterface.png" title="xampp-control-panel-change-apache-port-80-8080-userinterface" width="640" /></a></div><br /><b><span style="font-size: large;">Alternative: to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default</span></b><br /><br />You can configure XAMPP to open Apache and phpMyAdmin on port 8080 by default from XAMPP from the XAMPP userinterface itself as described in the video. Or you can also edit the settings in xampp-control.ini file as described below. <br /><ul style="text-align: left;"><li>Stop services from XAMPP Control Panel</li><li>Navigate to C:\xampp</li><li>Find the file xampp-control.ini</li><li>Open the file xampp-control.ini in a notepad to edit</li><li>Search for [ServicePorts]</li><li>Under [ServicePorts], change Apache=80 to Apache=8080</li><li>Save the file</li><li>Start Apache and MySQL Services from XAMPP Control Panel</li><li>Click on Admin button on XAMPP Control Panel corresponsing to Apache and phpMyAdmin</li><li>Apache and phpMyAdmin pages should open automatically using the port 8080</li></ul></div>

How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?

In this post we shall see How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default? XAMPP Control Panel tries to open th...

April 07, 2018

Unable to login to phpMyAdmin in XAMPP: Access denied for user 'root'@'localhost' (using password: NO)

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTNNYgxWI4johgzArqOnTgswhHEoxdDirG5brHgJkoMtK7e1xlFhx7-5pXMmgoKhf0ftbrKqhI9bpGn93Mc5dHmOtj5C1-fPYGsxM3823fNfDXAc6LTG-pdatAjeCVppuTTux2lw08960/s1600/unable-to-login-phpmyadmin-xampp-password-root.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="unable-to-login-phpmyadmin-xampp-password-root" border="0" data-original-height="430" data-original-width="610" height="450" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTNNYgxWI4johgzArqOnTgswhHEoxdDirG5brHgJkoMtK7e1xlFhx7-5pXMmgoKhf0ftbrKqhI9bpGn93Mc5dHmOtj5C1-fPYGsxM3823fNfDXAc6LTG-pdatAjeCVppuTTux2lw08960/s640/unable-to-login-phpmyadmin-xampp-password-root.png" title="unable-to-login-phpmyadmin-xampp-password-root" width="640"></a></div><div style="text-align: justify;"> </div><div style="text-align: justify;"><span style="font-size: large;"><b>Unable to login to XAMPP's phpMyAdmin page : Error #1045 - Access denied for user 'root'@'localhost' (using password: NO). </b></span><br>In this post we shall see how to set root password for phpMyAdmin to resolve the access denied error while accessing phpMyAdmin. This may usually happen if XAMPP is reinstalled on the same computer.<br><i><b></b></i></div></div><a href="https://techubber.blogspot.com/2017/11/phpmyadmin-access-denied-user-root-no-password-unable-login-phpmyadmin.html#more">Read more »</a>

Unable to login to phpMyAdmin in XAMPP: Access denied for user 'root'@'localhost' (using password: NO)

Unable to login to XAMPP's phpMyAdmin page : Error #1045 - Access denied for user 'root'@'localhost' (using password: ...

November 25, 2017

How to move website from XAMPP on one computer to XAMPP on another computer?

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;"><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-iO0gNEaUzm2Ru4G58xRaPw6lsjU0Vdsg6VZnZ2NPqLrsQDxmez5zDnW3VHybsGSYPcIZAlZB0SOfyVLEfl1ehaQr1Ymvo7z3i0hTL9_OObkblUgvS5rJ8VEtdk32wZv2N-mN5slvxek/s1600/How+to+website+from+XAMPP+on+one+computer+to+XAMPP+on+another+computer.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to website from XAMPP on one computer to XAMPP on another computer?" border="0" data-original-height="466" data-original-width="744" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-iO0gNEaUzm2Ru4G58xRaPw6lsjU0Vdsg6VZnZ2NPqLrsQDxmez5zDnW3VHybsGSYPcIZAlZB0SOfyVLEfl1ehaQr1Ymvo7z3i0hTL9_OObkblUgvS5rJ8VEtdk32wZv2N-mN5slvxek/s640/How+to+website+from+XAMPP+on+one+computer+to+XAMPP+on+another+computer.jpg" title="How to website from XAMPP on one computer to XAMPP on another computer?" width="640" /></a></div><br /></div><div style="text-align: justify;"><span style="font-size: small;">I normally use XAMPP for web development on my local Windows machine. And I needed to move the website files from one computer to another as I have a new Windows laptop on which I would be doing my web development activities from now on. So, I needed to move the existing website files from the older computer to the new computer, along with the database of the website. If you are in a similar situation, refer to the steps below how to move the websites from XAMPP on one computer to XAMPP on another computer.<br /><br /><br />XAMPP is a free and open source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database (supports MySQL) , and interpreters for scripts written in the PHP and Perl programming languages.<br /><br /><b>    X = Cross Platform / Any Operating System<br />    A = Apache Web Server<br />    M = MySQL / Maria DB<br />    P = PHP Programming Language<br />    P = Perl Programming Language</b><br />XAMPP is easy to install and packages all the above requirements of web development out of the box. There is minimal configuration required to kick start web development on local machine instead of installing all the above requirements manually. <br /><br /><br /><b><span style="font-size: large;">How to move websites from XAMPP on one computer to XAMPP on another computer?</span></b><br /><br /><br /><span style="font-size: large;">Assumptions / Pre-Requisites:</span><br /><br />So, I have been using XAMPP for web development on my local computer. I use WordPress and Drupal mostly, but there are some custom PHP sites too. In this post, I will be using one of the WordPress CMS site for the purpose of illustration in this post. On my system, XAMPP is installed at C drive at C:/xampp. Thus, website files are located under C:\xampp\htdocs directory.<br /><br /><br />For the steps explained below, it is assumed that XAMPP is installed on both the computers already.<br /><br /><br /><span style="font-size: x-large;">Steps to move websites from XAMPP on one computer to XAMPP on another computer. </span><br /><br />This method is not only for WordPress shown in this example. It can be used for any other CMS or sites. The basic process in a nutshell is to move the website folder to the new computer under the same folder, that is under C:\xampp\htdocs and move the database to the new computer<br /><br /><br /><b><span style="font-size: large;">1) Move website files from computer 1 to computer 2:</span></b><br /><br />    Copy the website folder you want to move from C:\xampp\htdocs\. For this example, the website folder to be copied is "techblog". Thus, I copied the folder C:\xampp\htdocs\techblog<br />    Move the website folder from the computer 1 to C:\xampp\htdocs\ on the computer 2 using any medium. For this example, the website folder copied is "techblog". So, we should have the website files in C:\xampp\htdocs\techblog. <br /><br />That is all that is required as far as moving the website files from one computer to another for using with XAMPP is concerned.<br /><br /><br /><span style="font-size: large;"><b>2) Export database of the website from computer 1</b></span><br /></span></div><ul style="text-align: left;"><li><span style="font-size: small;">    Open phpMyAdmin in a browser on computer 1 by accessing http://localhost/phpmyadmin</span></li><li><span style="font-size: small;">    Login to phpMyAdmin if a password is set for root</span></li><li><span style="font-size: small;">    Select the  database from the left sidebar of phpMyAdmin</span></li><li><span style="font-size: small;">    Click on STRUCTURE and check how many tables the database has. It is displayed at the bottom of the STRUCTURE page. Compare  the number of tables during import on computer 2.</span></li><li><span style="font-size: small;">    Now to export, click on EXPORT tab</span></li></ul><div style="text-align: justify;"><span style="font-size: small;"><br /></span></div><blockquote class="tr_bq"><i><span style="font-size: small;">        Note: For some CMS (such as Drupal, WordPress etc.) it is recommended to clear cache from the admin interface before exporting database to avoid any import issues and/or site issues after import. </span></i></blockquote><div style="text-align: justify;"><span style="font-size: small;"><br /></span></div><ul style="text-align: left;"><li><span style="font-size: small;">    Keep default settings and just click "GO" to export and download the database.</span></li><li><span style="font-size: small;">    An SQL file will be exported. Save it to computer 1</span></li></ul><div style="text-align: justify;"><span style="font-size: small;"> </span></div><div class="separator" style="clear: both; text-align: justify;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3vt4qm1Uj43zdJyGgHa2tCl6gQFmFcjKUgVP-pr7ivAFAHz5iiYbO-AzD5-wldWZ2YOI2MluuFaTejy_kaGlSzs4mTaE89T0Wmn3nInJoPnzFUgTk9CIPX3scPzPhCDGMC8g9nbE4-Jo/s1600/export+mysql+database+phpmyadmin+localhost.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="285" data-original-width="400" height="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3vt4qm1Uj43zdJyGgHa2tCl6gQFmFcjKUgVP-pr7ivAFAHz5iiYbO-AzD5-wldWZ2YOI2MluuFaTejy_kaGlSzs4mTaE89T0Wmn3nInJoPnzFUgTk9CIPX3scPzPhCDGMC8g9nbE4-Jo/s320/export+mysql+database+phpmyadmin+localhost.jpg" width="320" /></a></div><div style="text-align: justify;"><br /><br /><br /><br /><span style="font-size: large;"><b> 3) Import the exported database from computer 1 into computer 2</b></span><br /><br /><ul><li>    On computer 2, access http://localhost/phpMyAdmin and login if a password is set.</li><li>    Once logged in to phpMyAdmin, click on "databases" and create a new database. </li><li>    You can name the database whatever you want but preferably keep the same name so that settings need not be changed.</li><li>    Select the new database from the left sidebar</li><li>    Click Import.</li><li>    Click on the "Browse" button and locate the database we exported from the old computer.</li><li>    Keep default settings and just click "GO" to import the database.</li><li>    Once the database is installed, check the website on computer 2 by accessing http://localhost/techblog. If the database name was kept the same during new database creation on computer 2, there is no need to change database name in the website settings file.</li></ul><br /><b><span style="font-size: large;">Database import issues?</span></b><br /><br />Unable to import database into phpMyAdmin due to an error?<br /><br />If this is a new  XAMPP installation on the new computer without any setting changes so far, then the database might not have uploaded due to size limit. In that case, upload size need to be changed in php.ini file on computer 2.<br /><br /><br /><blockquote class="tr_bq"><i>        Error: No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration </i></blockquote><br /><span style="font-size: large;">If you are unable to import database into phpMyAdmin due to the above error, you would need to edit some settings in php.ini configuration file at C:\xampp\php\php.ini.</span><br /><br /><br /><ul><li>    Open php.ini in a notepad, preferably Notepad++ and edit the values of the following parameters. I increased the following parameters to:</li></ul><br /><blockquote class="tr_bq"><i>        post_max_size = 50M<br />        upload_max_filesize =50M<br />        max_execution_time=200<br />        max_input_time=200</i></blockquote><br />Since it is a development environment, you can set it to any reasonable value. On live server, these parameters will usually be controlled by your web host service provider. and you may not have access to php.ini. <br /><br /><ul><li>    After changing the values of the above parameters, restart Apache from XAMPP control panel.</li></ul><ul><li>    Retry the import of SQL database into phpMyAdmin. It should be resolved now.</li></ul><br /><br /><span style="font-size: large;">How to prepare the SQL database file before import if the XAMPP on the previous computer was using another port for such as "localhost:8080" instead of the default "localhost"</span><br /><br />If on the previous computer 1, XAMPP was set to use "localhost:8080" instead of "localhost" to access web pages but on the new computer it is using the default "localhost" to access web pages, then the website on computer 2 will not work properly as the database has referenced to "http://localhost:port-number/websitename". Sometimes, people have multiple web servers on a single computer such as IIS and Apache from XAMPP. In that case, the default HTTP port 80 may already be used by the other web server. So, Apache is assigned another port to use.<br /><br /><br />We can edit the URLs containing the "localhost:8080" from phpMyAdmin with simple SQL querries but I find it easier to edit it using text editors by using simpler "find and replace" feature. We can find all reference of "localhost:8080" and replace them with "localhost" only. For this purpose <a href="https://notepad-plus-plus.org/" rel="nofollow" target="_blank">Notepad++</a> is good instead of Notepad.<br /><br /><ul><li>    Open the databasename.sql exported from the previous XAMPP in a Notepad or Notepad++</li><li>    Press CTRL+F and search for "localhost:8080". You should be able to see some results.</li><li>    Now replace all instances of "localhost:8080" with "localhost" by doing replace all.</li><li>    Save the edited SQL file or "Save As" with a new name</li><li>    Use this edited SQL file in the phpMyAdmin import (described above).</li></ul><br /><br /><span style="font-size: x-large;">Other related posts:</span><br /><br />    <a href="https://techubber.blogspot.com/2013/07/How-to-install-and-run-XAMPP-on-Windows.html">How to install and run XAMPP on Windows?</a><br />    <a href="https://techubber.blogspot.com/2016/06/how-to-migrate-site-from-local-server-to-live-server.html">How to migrate site from local development machine to live site?</a><br />    <a href="https://techubber.blogspot.com/2013/09/how-to-install-and-run-wordpress-on-windows-using-xampp.html">How to install and run WordPress using XAMPP on Windows?</a><br /></div></div>  <div><p> Popular computers on Amazon </p><script type="text/javascript">amzn_assoc_ad_type ="responsive_search_widget"; amzn_assoc_tracking_id ="techubber-21"; amzn_assoc_marketplace ="amazon"; amzn_assoc_region ="IN"; amzn_assoc_placement =""; amzn_assoc_search_type = "search_widget";amzn_assoc_width ="auto"; amzn_assoc_height ="auto"; amzn_assoc_default_search_category =""; amzn_assoc_default_search_key ="computer";amzn_assoc_theme ="light"; amzn_assoc_bg_color ="FFFFFF"; </script><script src="//z-in.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&Operation=GetScript&ID=OneJS&WS=1&Marketplace=IN"></script></div>

How to move website from XAMPP on one computer to XAMPP on another computer?

I normally use XAMPP for web development on my local Windows machine. And I needed to move the website files from one computer to another as...

June 01, 2017

How to move website from XAMPP on one computer to XAMPP on another computer?

How to move website from XAMPP on one computer to XAMPP on another computer?

I normally use XAMPP for web development on my local Windows machine. And I needed to move the website files from one computer to another as...

June 01, 2017

XAMPP Server | Apache Service Unable To Start Due To uTorrent

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX-jOKR_RvVt7fos-kKIc-_u-V1myV3sMQr30uqeMlfUXGtlHhtaDsLPnbwRdfaJlGHZKoqT4C8HyY-lW_cNQ-GVSUj4Kuz00JFv3EpXegIhF5SVQvl1Av6KaHLQ2JNh_r1qxuXqtL0Ac/s1600/XAMPP+Server++Apache+Service+Unable+To+Start+Due+To+uTorrent.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="XAMPP Server Apache Service Unable To Start Due To uTorrent" border="0" height="311" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX-jOKR_RvVt7fos-kKIc-_u-V1myV3sMQr30uqeMlfUXGtlHhtaDsLPnbwRdfaJlGHZKoqT4C8HyY-lW_cNQ-GVSUj4Kuz00JFv3EpXegIhF5SVQvl1Av6KaHLQ2JNh_r1qxuXqtL0Ac/s400/XAMPP+Server++Apache+Service+Unable+To+Start+Due+To+uTorrent.jpg" title="XAMPP Server Apache Service Unable To Start Due To uTorrent" width="400"></a></div><b>Issue: </b>XAMPP Server Apache Service unable to Start<br></div><a href="https://techubber.blogspot.com/2017/05/xampp-server-apache-service-unable-to-start-error-port-number-utorrent.html#more">Read more »</a>

XAMPP Server | Apache Service Unable To Start Due To uTorrent

Issue: XAMPP Server Apache Service unable to Start Read more »

May 26, 2017