This error appeared overnight. Can't seem to fix this.

I have renamed the data folder and reinitialized. This works, but then I lose all my databases.

Is there another fix for this?

I need to get around the endless problem of:

Expression #2 of SELECT list is not in GROUP BY clause
and contains nonaggregated column 'test.web_log.user_id' which is not functionally
dependent on columns in GROUP BY clause; this is incompatible
with sql_mode=only_full_group_by

The only way I can get around the error and still have the query I want is to permanently disable "only_full_group_by". I found an article which I believe (I could be wrong) only disables it temporarily for the active session, Like this:

mysql> SET GLOBAL sql_mode='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION';

OR//

mysql> SET GLOBAL sql_mode='';

So I need to disable it permanently.

Any Ideas how I do that in Laragon? I have spent too long with Linux

Many thanks!

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

I just started using Laragon yesterday to locally stage a clone of my existing Wordpress site. It's working great (SO much better than Local by Flywheel!), except for this one issue...

Background: I set up my Wordpress site files and database, change the mysql root user password (or not, I've tried it both ways), and I can access my site perfectly (Wordpress talks to the db and my site looks normal, I can access the database in the command line or phpMyAdmin, all good).

Problem: BUT if I restart my system (Windows 10), the database is no longer accessible: I get "database error" when I visit my local site, and mysql (via command line) and phpMyAdmin both return

"Access denied for user 'root'@'localhost' (using password: YES)"

Things I've tried: I've uninstalled and reinstalled Laragon a number of times with various tweaks to try and troubleshoot this issue on my own. Here's what I've tried:

leaving the default (blank) mysql password changing the mysql root password through command line changing mysql root password through phpMyAdmin setting the initial mysql password in my.ini changing $cfg['blowfish_secret'] in phpMyAdmin/config.inc.php (just for the hell of it)

Note: anytime I change the mysql password, I change the wp-config.php to match.

Mysql is still accessible when I stop or exit Laragon, then start it back up again, as long as I don't reboot. But as soon as I reboot, mysql is no longer accessible.

Presumably, the root password is being changed during the reboot. Is this the case? Why is that? And what is the solution?

Thanks in advance for any guidance you can give!

-- Will --

Is there a way with laragon to create new root user for mysql or is it only able to reset password?

im not sure that im dealing with laragon issue but im getting a 500 internal server error. I read that perhaps the memory needed to be adjusted so i tried doing that with no luck. It could still be an issue with my laravel backend using passport but all routes work except for login route that deals with access token.

below is the log that im getting. any help would be greatly appreciated

GuzzleHttp\Exception\RequestException: cURL error 3: <url> malformed (see http://curl.haxx.se/libcurl/c/libcurl-errors.html) in file C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php on line 186
Stack trace:

GuzzleHttp\Exception\RequestException->() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php:186 GuzzleHttp\Handler\CurlFactory->createRejection() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php:149 GuzzleHttp\Handler\CurlFactory->finishError() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php:102 GuzzleHttp\Handler\CurlFactory->finish() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\CurlHandler.php:43 GuzzleHttp\Handler\CurlHandler->__invoke() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php:28 GuzzleHttp\Handler\Proxy->GuzzleHttp\Handler{closure}() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php:51 GuzzleHttp\Handler\Proxy->GuzzleHttp\Handler{closure}() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\PrepareBodyMiddleware.php:66 GuzzleHttp\PrepareBodyMiddleware->__invoke() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Middleware.php:30 GuzzleHttp\Middleware->GuzzleHttp{closure}() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\RedirectMiddleware.php:70 GuzzleHttp\RedirectMiddleware->__invoke() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Middleware.php:60 GuzzleHttp\Middleware->GuzzleHttp{closure}() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\HandlerStack.php:67 GuzzleHttp\HandlerStack->__invoke() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Client.php:277 GuzzleHttp\Client->transfer() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Client.php:125 GuzzleHttp\Client->requestAsync() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Client.php:131 GuzzleHttp\Client->request() C:\laragon\www\traxit\vendor\guzzlehttp\guzzle\src\Client.php:89 GuzzleHttp\Client->__call() C:\laragon\www\traxit\app\Http\Controllers\AuthController.php:22 App\Http\Controllers\AuthController->login() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Controller.php:54 call_user_func_array() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Controller.php:54 Illuminate\Routing\Controller->callAction() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php:45 Illuminate\Routing\ControllerDispatcher->dispatch() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Route.php:212 Illuminate\Routing\Route->runController() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Route.php:169 Illuminate\Routing\Route->run() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Router.php:679 Illuminate\Routing\Router->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php:41 Illuminate\Routing\Middleware\SubstituteBindings->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php:57 Illuminate\Routing\Middleware\ThrottleRequests->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:104 Illuminate\Pipeline\Pipeline->then() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Router.php:681 Illuminate\Routing\Router->runRouteWithinStack() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Router.php:656 Illuminate\Routing\Router->runRoute() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Router.php:622 Illuminate\Routing\Router->dispatchToRoute() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Router.php:611 Illuminate\Routing\Router->dispatch() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:176 Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\spatie\laravel-cors\src\Cors.php:28 Spatie\Cors\Cors->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\fideloper\proxy\src\TrustProxies.php:57 Fideloper\Proxy\TrustProxies->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:31 Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:31 Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php:27 Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php:62 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\barryvdh\laravel-cors\src\HandlePreflight.php:29 Barryvdh\Cors\HandlePreflight->handle() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 Illuminate\Routing\Pipeline->Illuminate\Routing{closure}() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:104 Illuminate\Pipeline\Pipeline->then() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:151 Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() C:\laragon\www\traxit\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:116 Illuminate\Foundation\Http\Kernel->handle() C:\laragon\www\traxit\public\index.php:55

hello, i have some problem after i restart my pc

now its show me this error
when i open phpmyadmin or any web app
#2002 - No connection could be made because the target machine actively refused it. — The server is not responding (or the local server's socket is not correctly configured).

from cmder i got this

C:\Users\Eng Ahmed>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")

i try to reinstall laragon but still same issue. i dono if i move the files to another PC it will work or know, but i need to solve this issue.

waiting for your reply

I have set up Laragon to work with OctoberCMS and a database using HeidiSQL (synced to Laragon). Everything works well until I get to the point where I need to connect OctoberCMS to the database (in my case, MySQL).

This is what happens...

I run the command php artisan october:install and fill in the required information (database name, port, password, etc). However, when all is said and done, I get the following message:

could not find driver

Any idea what is happening and how to fix it?

Thanks.

on mysql tpl can you please add this show_compatibility_56=on

Hi guys,

This code fragment Homestead in the works , but it does not work Laragon.

Database manual gives an error occurs if you laravel :
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin.permissions' doesn't exist (SQL: select * from permissions)

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateRolePermissions extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('roles', function(Blueprint $table){
$table->increments('id');
$table->string('name');
$table->string('label');
$table->timestamps();

}); Schema::create('permissions', function(Blueprint $table){ $table->increments('id'); $table->string('name'); $table->string('label'); $table->timestamps(); }); Schema::create('permission_role', function(Blueprint $table){ $table->integer('role_id')->unsigined(); $table->integer('permission_id')->unsigined(); $table->foreign('role_id') ->referance('id') ->on('roles') ->onDelete('cascade'); $table->foreign('permission_id') ->referance('id') ->on('permissions') ->onDelete('cascade'); $table->primary(['role_id', 'permission_id']); }); Schema::create('role_user', function(Blueprint $table){ $table->integer('role_id')->unsigined(); $table->integer('user_id')->unsigined(); $table->foreign('role_id') ->referance('id') ->on('roles') ->onDelete('cascade'); $table->foreign('user_id') ->referance('id') ->on('users') ->onDelete('cascade'); $table->primary(['role_id', 'user_id']); }); } /** * Reverse the migrations. * * @return void */ public function down() { \DB::statement('SET FOREIGN_KEY_CHECKS = 0'); Schema::drop('roles'); Schema::drop('permissions'); Schema::drop('permission_role'); Schema::drop('role_user'); \DB::statement('SET FOREIGN_KEY_CHECKS = 1'); }

}