I was using Xampp for local development until about a year ago when I found Laragon & I haven't looked back since. This is seriously the most powerful local development tool I have in my entire "developer toolkit".
I started working for a new company about 2 months ago & their entire team was using various setups for local dev and were always encountering problems. Setting up a new project locally was always a nightmare for them due to mysql version conflicts, having to change php versions, etc. When I introduced Laragon to them, they were amazed at how easy it was to install, maintain and how flexible it was to update/switch their dependencies. My manager told me that since the team has started using Laragon for local dev, project setup time has gone down from an average of 6 HOURS, to less than 30 mins. AMAZING.
In the opensource community, people sometimes forget the amount of time, effort and hard work that goes into creating something like this. So the reason why I'm posting this is just to say thank you to @leokhoa for developing & maintaining such an incredible piece of software. Your amazing efforts are very much appreciated!

I got a new workstation laptop at work and I of course I use Laragon for my local dev server needs. I am running into this issue where whenever any server request is made there is a HUGE request wait times of over 2 seconds in my laravel application. If I create a simple 2 page html product that just have a anchor to each page navigation is super fast.

Any ideas as to why I am seeing this long wait time? I am including a screenshot to my "main" page of my laravel project to show the timings from the network tab of the initial get request when hitting the root endpoint. The rest of the requests (loading js, css, font awesome, etc.) are all maxed out at 158ms of wait time.

Can you add a similar functionality to user.cmd for Laragon Stop, to set a script to execute before Laragon exit?

Re: how do I surf in to my .dev site from my android if I am on same wifi

I found this post that describes my issue by @nermamax, it's from 2017 so I was advised to start a new thread.
the solution was:
*server {
listen 80;
server_name myapp.dev .myapp.dev 192.168.1.80;
but I don't quiet understand how to put this into action or in my address bar,
so for example, if my IP to my wired (lan) desktop is:
10.0.0.62
and my Laragon localhost site is:
test.test
does that mean that I should use the address in my Android address bar (wifi):
test.test/10.0.0.62:80/ ?
It must not be right as it's not working.

Thanks for any help

This topic from Laragon menu is with access denied "https://forum.laragon.org/topic/1018":

I have a query like this

SELECT tt.* FROM `laravel-sb`.`chats` tt INNER JOIN (SELECT chatroom_id, MAX(created_at) AS MaxDateTime FROM `laravel-sb`.`chats` WHERE `receiver_id`=7 GROUP BY chatroom_id) groupedtt ON tt.chatroom_id = groupedtt.chatroom_id AND tt.created_at = groupedtt.MaxDateTime WHERE `receiver_id`=7 -- and `sender_id` = 1 Order By Not isNull( seen_at ), created_at DESC, millisecond DESC

I try to put it into laravel like this

$query = DB::select( DB::raw('select tt.* FROM `chats` tt INNER JOIN (SELECT chatroom_id, MAX(created_at) AS MaxDateTime FROM `chats` WHERE `receiver_id`= ' . $profileId . ' GROUP BY chatroom_id) groupedtt ON tt.chatroom_id = groupedtt.chatroom_id AND tt.created_at = groupedtt.MaxDateTime WHERE `receiver_id`= ' . $profileId . ' Order By Not isNull( seen_at ), created_at DESC, millisecond DESC ') )->get();

The query works in my sql editor, but not in laravel.

I get the error:
Illuminate/Database/QueryException with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea

SERVICE Apache can not start, Reason

Port 80 is use!

To find out which program is using the port.

Click Menu >tools>netstat.

any help , thanks

I'am using Laragon 4.0.16 (190914) and MySQL 8.0.16 but when I want to start MySQL server it throws an error "Service MySQL can not start. Reason: Unknown. Please check MySQL log file".

I'am on Windows 10.

Attached is MySQL log file for review : 0_1574132412948_mysqld.log

Can you add auto set and unset Path Environment Variables on Start All and Stop actions as options in General Preferences for more portability?

Hi,
I have recently Installed laragon 4.0.15 on windows 10 and when i start the servers Apache works fine but for MySQL i get this error message saying MySQL can't start reason Can't create test file C:\laragon\data\mysql???.lower-test,
Now What's causing this error???
I've set full permission to C:\laragon Folder It still doesn't work, then i completely removed it and installed it again on (D:) Drive Still doesn't seem to work.....
any Help?????

Please HELP ME:

I for some reason deleted the ibdata1, ib_logfile1, ib_logfile0 mysql data folder, then i realized all my databases are gone. I have also cleared my recycle bin.

Is a there a way I can recover or restore the databases?

Thank you.

Re: Avoid Site access with url.dev:8888/ with Nginx

This is an older topic, but though the previous solution (in the link referenced) of swapping the Nginx Port numbers with Apache ports numbers is pretty hacky.

Though it's a quick solution that works, I'm left wondering... Is there a better way to get Pretty URL's using Nginx on Windows besides swapping the port numbers?

Want to change this: https://mysite.oo:8443 to only this: https://mysite.oo

Anyone know how to solve this? The apache failed to start after i switched my php from 7.2.19 to 5.6.9. Thanks

You can also add/update phpMyAdmin easily yourself. Just download from its official site (https://www.phpmyadmin.net/downloads) and extract to {LARAGON_DIR}\etc\apps\phpMyAdmin.
That's all.

Now, you can acess phpMyAdmin at:
http://localhost/phpmyadmin

In a specific folder, where my working directory is specified. I just want to open sublime/notepad++ by typing a certain word like sublime or subl . just like in Linux. How would I do that in cmder ?

I recently installed Laragon and updated php to 7.VC15 x64 TS and updated MySQL to 8.0.18 winx64 However MySQL fails to start. The error log shows the following:

2019-10-25T19:25:57.983319Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2019-10-25T19:25:58.535346Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-25T19:25:58.924966Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-25T19:25:59.026855Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-25T19:25:59.031943Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2019-10-25T19:25:59.033424Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2019-10-25T19:25:59.035749Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2019-10-25T19:25:59.039508Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-10-25T19:25:59.041000Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2019-10-25T19:25:59.047275Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-25T19:26:00.287089Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.18-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.

I thought that I should be able to easily switch between MySQL/MariaDB versions. Apparently I was wrong.

Any help will be greatly appreciated

Hello people. I hope you are all good, I discovered the laragon recently and brother, this is going to take the place of xammp quickly, is a very, very very good server.

I want help with something, I have a local network, and I'm using laragon to host sites that will only be accessible to anyone on the network, but I can only access the site through the ip address of the machine where is installed argon, I happen to not want it to be ip, I want it to be a domain name just like the localtunnel program but with a custom url.

I researched some programs like ngrok, and if paying for this program puts my site online I do not want it, I want it to be accessed only on the local network but with a domain name without ip

can you help me please.

I am getting below error

I've already edited the httpd.conf. Mod_rewrite is enabled.

LoadModule rewrite_module modules/mod_rewrite.so

DocumentRoot "C:/Users/mda/Desktop/Work/example.com"
<Directory "C:/Users/mda/Desktop/Work/example.com">
Options All
AllowOverride All
order allow,deny
allow from all
</Directory>

Have a .htaccess file in document root. No matter what i change it to, nothing happens How do i solve?

In my config file I have set: define('BASE', 'http://site.test/');

In production it works (changing .test to .com), but in the localhost, no one of the links work (css, js, nothing). In view-source I see something like: <link rel="stylesheet" href="http://site.test/assets/bootstrap/css/bootstrap.css">, and if I click on it, it give me the DNS_PROBE_FINISHED_NXDOMAIN message.