Laravel 5.5 with MySQL 8.0.11: 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE

Laravel 5.5 with MySQL 8.0.11: 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

up vote
9
down vote

favorite

I've just installed MySQL 8.0.11, transfered my app's database into it and changed the laravel database settings to use the new one. Now everytime I try to login I get the following error:

ERROR 1231 (42000):

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I tried to set NO_AUTO_CREATE_USER manually:

set global sql_mode="..., NO_AUTO_CREATE_USER, ...";

But I get the same error. How could I solve the problem and run laravel 5.5 with MySQL 8.0.11?

asked Apr 27 at 18:54

chevallier

2941415

add a comment |

up vote
9
down vote

favorite

I've just installed MySQL 8.0.11, transfered my app's database into it and changed the laravel database settings to use the new one. Now everytime I try to login I get the following error:

ERROR 1231 (42000):

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I tried to set NO_AUTO_CREATE_USER manually:

set global sql_mode="..., NO_AUTO_CREATE_USER, ...";

But I get the same error. How could I solve the problem and run laravel 5.5 with MySQL 8.0.11?

asked Apr 27 at 18:54

chevallier

2941415

add a comment |

up vote
9
down vote

favorite

I've just installed MySQL 8.0.11, transfered my app's database into it and changed the laravel database settings to use the new one. Now everytime I try to login I get the following error:

ERROR 1231 (42000):

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I tried to set NO_AUTO_CREATE_USER manually:

set global sql_mode="..., NO_AUTO_CREATE_USER, ...";

But I get the same error. How could I solve the problem and run laravel 5.5 with MySQL 8.0.11?

asked Apr 27 at 18:54

chevallier

2941415

I've just installed MySQL 8.0.11, transfered my app's database into it and changed the laravel database settings to use the new one. Now everytime I try to login I get the following error:

ERROR 1231 (42000):

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I tried to set NO_AUTO_CREATE_USER manually:

set global sql_mode="..., NO_AUTO_CREATE_USER, ...";

But I get the same error. How could I solve the problem and run laravel 5.5 with MySQL 8.0.11?

mysql laravel laravel-5.5

asked Apr 27 at 18:54

chevallier

2941415

asked Apr 27 at 18:54

chevallier

2941415

asked Apr 27 at 18:54

chevallier

2941415

asked Apr 27 at 18:54

chevallier

2941415

asked Apr 27 at 18:54

chevallier

2941415

add a comment |

5 Answers
5

active

oldest

votes

up vote
6
down vote

accepted

The next release of Laravel 5.5 will add support for MySQL 8.0: https://github.com/laravel/framework/pull/24038

UPDATE: Laravel 5.5.41 has been released.

edited Aug 1 at 16:37

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

Thanks. Do you know any timeline when this will be released?
– Bobby
May 2 at 8:56

I asked for a new release.
– Jonas Staudenmeir
May 2 at 9:06

Laravel 5.5.41 has been released.
– Jonas Staudenmeir
Aug 1 at 16:36

add a comment |

up vote
11
down vote

your laravel connexion (config / database.php) should be such that:

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', 'localhost'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'forge'),

        'username' => env('DB_USERNAME', 'forge'),

        'password' => env('DB_PASSWORD', ''),

        'charset' => 'utf8',

        'collation' => 'utf8_unicode_ci',

        'prefix' => '',

        'strict' => true,

        'engine' => null,

        'modes'  => [

            'ONLY_FULL_GROUP_BY',

            'STRICT_TRANS_TABLES',

            'NO_ZERO_IN_DATE',

            'NO_ZERO_DATE',

            'ERROR_FOR_DIVISION_BY_ZERO',

            'NO_ENGINE_SUBSTITUTION',

            ],

    ],

answered May 24 at 16:42

eValdezate

1293

works for me as well Laravel 5.3 using mysql 8.xx
– Kruze
Nov 9 at 2:58

add a comment |

up vote
4
down vote

Add the following on each of your MySQL connections:

'modes' => [

     'ONLY_FULL_GROUP_BY',

     'STRICT_TRANS_TABLES',

     'NO_ZERO_IN_DATE',

     'NO_ZERO_DATE',

     'ERROR_FOR_DIVISION_BY_ZERO',

     'NO_ENGINE_SUBSTITUTION',

],

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

answered May 31 at 7:23

nasirkhan

5,74631524

add a comment |

up vote
2
down vote

MySQL 8.0 does not support NO_AUTO_CREATE_USER

Documentation: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

answered May 26 at 7:53

KAGG Design

989410

add a comment |

up vote
0
down vote

This codes work for me. Thanks.

'mysql' => [

    'driver' => 'mysql',

    'host' => env('DB_HOST', 'localhost'),

    'port' => env('DB_PORT', '3306'),

    'database' => env('DB_DATABASE', 'forge'),

    'username' => env('DB_USERNAME', 'forge'),

    'password' => env('DB_PASSWORD', ''),

    'charset' => 'utf8',

    'collation' => 'utf8_unicode_ci',

    'prefix' => '',

    'strict' => true,

    'engine' => null,

    'modes'  => [

        'ONLY_FULL_GROUP_BY',

        'STRICT_TRANS_TABLES',

        'NO_ZERO_IN_DATE',

        'NO_ZERO_DATE',

        'ERROR_FOR_DIVISION_BY_ZERO',

        'NO_ENGINE_SUBSTITUTION',

        ],

],

answered yesterday

ingafter60

New contributor

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f50068663%2flaravel-5-5-with-mysql-8-0-11-sql-mode-cant-be-set-to-the-value-of-no-auto%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

5 Answers
5

active

oldest

votes

5 Answers
5

active

oldest

votes

up vote
6
down vote

accepted

The next release of Laravel 5.5 will add support for MySQL 8.0: https://github.com/laravel/framework/pull/24038

UPDATE: Laravel 5.5.41 has been released.

edited Aug 1 at 16:37

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

Thanks. Do you know any timeline when this will be released?
– Bobby
May 2 at 8:56

I asked for a new release.
– Jonas Staudenmeir
May 2 at 9:06

Laravel 5.5.41 has been released.
– Jonas Staudenmeir
Aug 1 at 16:36

add a comment |

up vote
6
down vote

accepted

The next release of Laravel 5.5 will add support for MySQL 8.0: https://github.com/laravel/framework/pull/24038

UPDATE: Laravel 5.5.41 has been released.

edited Aug 1 at 16:37

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

Thanks. Do you know any timeline when this will be released?
– Bobby
May 2 at 8:56

I asked for a new release.
– Jonas Staudenmeir
May 2 at 9:06

Laravel 5.5.41 has been released.
– Jonas Staudenmeir
Aug 1 at 16:36

add a comment |

up vote
6
down vote

accepted

The next release of Laravel 5.5 will add support for MySQL 8.0: https://github.com/laravel/framework/pull/24038

UPDATE: Laravel 5.5.41 has been released.

edited Aug 1 at 16:37

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

The next release of Laravel 5.5 will add support for MySQL 8.0: https://github.com/laravel/framework/pull/24038

UPDATE: Laravel 5.5.41 has been released.

edited Aug 1 at 16:37

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

edited Aug 1 at 16:37

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

answered Apr 29 at 13:42

Jonas Staudenmeir

11.6k2932

Thanks. Do you know any timeline when this will be released?
– Bobby
May 2 at 8:56

I asked for a new release.
– Jonas Staudenmeir
May 2 at 9:06

Laravel 5.5.41 has been released.
– Jonas Staudenmeir
Aug 1 at 16:36

add a comment |

Thanks. Do you know any timeline when this will be released?
– Bobby
May 2 at 8:56

I asked for a new release.
– Jonas Staudenmeir
May 2 at 9:06

Laravel 5.5.41 has been released.
– Jonas Staudenmeir
Aug 1 at 16:36

Thanks. Do you know any timeline when this will be released?
– Bobby
May 2 at 8:56

I asked for a new release.
– Jonas Staudenmeir
May 2 at 9:06

Laravel 5.5.41 has been released.
– Jonas Staudenmeir
Aug 1 at 16:36

add a comment |

up vote
11
down vote

your laravel connexion (config / database.php) should be such that:

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', 'localhost'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'forge'),

        'username' => env('DB_USERNAME', 'forge'),

        'password' => env('DB_PASSWORD', ''),

        'charset' => 'utf8',

        'collation' => 'utf8_unicode_ci',

        'prefix' => '',

        'strict' => true,

        'engine' => null,

        'modes'  => [

            'ONLY_FULL_GROUP_BY',

            'STRICT_TRANS_TABLES',

            'NO_ZERO_IN_DATE',

            'NO_ZERO_DATE',

            'ERROR_FOR_DIVISION_BY_ZERO',

            'NO_ENGINE_SUBSTITUTION',

            ],

    ],

answered May 24 at 16:42

eValdezate

1293

works for me as well Laravel 5.3 using mysql 8.xx
– Kruze
Nov 9 at 2:58

add a comment |

up vote
11
down vote

your laravel connexion (config / database.php) should be such that:

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', 'localhost'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'forge'),

        'username' => env('DB_USERNAME', 'forge'),

        'password' => env('DB_PASSWORD', ''),

        'charset' => 'utf8',

        'collation' => 'utf8_unicode_ci',

        'prefix' => '',

        'strict' => true,

        'engine' => null,

        'modes'  => [

            'ONLY_FULL_GROUP_BY',

            'STRICT_TRANS_TABLES',

            'NO_ZERO_IN_DATE',

            'NO_ZERO_DATE',

            'ERROR_FOR_DIVISION_BY_ZERO',

            'NO_ENGINE_SUBSTITUTION',

            ],

    ],

answered May 24 at 16:42

eValdezate

1293

works for me as well Laravel 5.3 using mysql 8.xx
– Kruze
Nov 9 at 2:58

add a comment |

up vote
11
down vote

your laravel connexion (config / database.php) should be such that:

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', 'localhost'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'forge'),

        'username' => env('DB_USERNAME', 'forge'),

        'password' => env('DB_PASSWORD', ''),

        'charset' => 'utf8',

        'collation' => 'utf8_unicode_ci',

        'prefix' => '',

        'strict' => true,

        'engine' => null,

        'modes'  => [

            'ONLY_FULL_GROUP_BY',

            'STRICT_TRANS_TABLES',

            'NO_ZERO_IN_DATE',

            'NO_ZERO_DATE',

            'ERROR_FOR_DIVISION_BY_ZERO',

            'NO_ENGINE_SUBSTITUTION',

            ],

    ],

answered May 24 at 16:42

eValdezate

1293

your laravel connexion (config / database.php) should be such that:

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', 'localhost'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'forge'),

        'username' => env('DB_USERNAME', 'forge'),

        'password' => env('DB_PASSWORD', ''),

        'charset' => 'utf8',

        'collation' => 'utf8_unicode_ci',

        'prefix' => '',

        'strict' => true,

        'engine' => null,

        'modes'  => [

            'ONLY_FULL_GROUP_BY',

            'STRICT_TRANS_TABLES',

            'NO_ZERO_IN_DATE',

            'NO_ZERO_DATE',

            'ERROR_FOR_DIVISION_BY_ZERO',

            'NO_ENGINE_SUBSTITUTION',

            ],

    ],

answered May 24 at 16:42

eValdezate

1293

answered May 24 at 16:42

eValdezate

1293

answered May 24 at 16:42

eValdezate

1293

answered May 24 at 16:42

eValdezate

1293

works for me as well Laravel 5.3 using mysql 8.xx
– Kruze
Nov 9 at 2:58

add a comment |

works for me as well Laravel 5.3 using mysql 8.xx
– Kruze
Nov 9 at 2:58

works for me as well Laravel 5.3 using mysql 8.xx
– Kruze
Nov 9 at 2:58

add a comment |

up vote
4
down vote

Add the following on each of your MySQL connections:

'modes' => [

     'ONLY_FULL_GROUP_BY',

     'STRICT_TRANS_TABLES',

     'NO_ZERO_IN_DATE',

     'NO_ZERO_DATE',

     'ERROR_FOR_DIVISION_BY_ZERO',

     'NO_ENGINE_SUBSTITUTION',

],

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

answered May 31 at 7:23

nasirkhan

5,74631524

add a comment |

up vote
4
down vote

Add the following on each of your MySQL connections:

'modes' => [

     'ONLY_FULL_GROUP_BY',

     'STRICT_TRANS_TABLES',

     'NO_ZERO_IN_DATE',

     'NO_ZERO_DATE',

     'ERROR_FOR_DIVISION_BY_ZERO',

     'NO_ENGINE_SUBSTITUTION',

],

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

answered May 31 at 7:23

nasirkhan

5,74631524

add a comment |

up vote
4
down vote

Add the following on each of your MySQL connections:

'modes' => [

     'ONLY_FULL_GROUP_BY',

     'STRICT_TRANS_TABLES',

     'NO_ZERO_IN_DATE',

     'NO_ZERO_DATE',

     'ERROR_FOR_DIVISION_BY_ZERO',

     'NO_ENGINE_SUBSTITUTION',

],

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

answered May 31 at 7:23

nasirkhan

5,74631524

Add the following on each of your MySQL connections:

'modes' => [

     'ONLY_FULL_GROUP_BY',

     'STRICT_TRANS_TABLES',

     'NO_ZERO_IN_DATE',

     'NO_ZERO_DATE',

     'ERROR_FOR_DIVISION_BY_ZERO',

     'NO_ENGINE_SUBSTITUTION',

],

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

answered May 31 at 7:23

nasirkhan

5,74631524

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

edited Nov 9 at 18:57

Ivanka Todorova

5,806124376

answered May 31 at 7:23

nasirkhan

5,74631524

answered May 31 at 7:23

nasirkhan

5,74631524

answered May 31 at 7:23

nasirkhan

5,74631524

add a comment |

up vote
2
down vote

MySQL 8.0 does not support NO_AUTO_CREATE_USER

Documentation: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

answered May 26 at 7:53

KAGG Design

989410

add a comment |

up vote
2
down vote

MySQL 8.0 does not support NO_AUTO_CREATE_USER

Documentation: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

answered May 26 at 7:53

KAGG Design

989410

add a comment |

up vote
2
down vote

MySQL 8.0 does not support NO_AUTO_CREATE_USER

Documentation: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

answered May 26 at 7:53

KAGG Design

989410

MySQL 8.0 does not support NO_AUTO_CREATE_USER

Documentation: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

answered May 26 at 7:53

KAGG Design

989410

answered May 26 at 7:53

KAGG Design

989410

answered May 26 at 7:53

KAGG Design

989410

answered May 26 at 7:53

KAGG Design

989410

add a comment |

up vote
0
down vote

This codes work for me. Thanks.

'mysql' => [

    'driver' => 'mysql',

    'host' => env('DB_HOST', 'localhost'),

    'port' => env('DB_PORT', '3306'),

    'database' => env('DB_DATABASE', 'forge'),

    'username' => env('DB_USERNAME', 'forge'),

    'password' => env('DB_PASSWORD', ''),

    'charset' => 'utf8',

    'collation' => 'utf8_unicode_ci',

    'prefix' => '',

    'strict' => true,

    'engine' => null,

    'modes'  => [

        'ONLY_FULL_GROUP_BY',

        'STRICT_TRANS_TABLES',

        'NO_ZERO_IN_DATE',

        'NO_ZERO_DATE',

        'ERROR_FOR_DIVISION_BY_ZERO',

        'NO_ENGINE_SUBSTITUTION',

        ],

],

answered yesterday

ingafter60

New contributor

add a comment |

up vote
0
down vote

This codes work for me. Thanks.

'mysql' => [

    'driver' => 'mysql',

    'host' => env('DB_HOST', 'localhost'),

    'port' => env('DB_PORT', '3306'),

    'database' => env('DB_DATABASE', 'forge'),

    'username' => env('DB_USERNAME', 'forge'),

    'password' => env('DB_PASSWORD', ''),

    'charset' => 'utf8',

    'collation' => 'utf8_unicode_ci',

    'prefix' => '',

    'strict' => true,

    'engine' => null,

    'modes'  => [

        'ONLY_FULL_GROUP_BY',

        'STRICT_TRANS_TABLES',

        'NO_ZERO_IN_DATE',

        'NO_ZERO_DATE',

        'ERROR_FOR_DIVISION_BY_ZERO',

        'NO_ENGINE_SUBSTITUTION',

        ],

],

answered yesterday

ingafter60

New contributor

add a comment |

up vote
0
down vote

This codes work for me. Thanks.

'mysql' => [

    'driver' => 'mysql',

    'host' => env('DB_HOST', 'localhost'),

    'port' => env('DB_PORT', '3306'),

    'database' => env('DB_DATABASE', 'forge'),

    'username' => env('DB_USERNAME', 'forge'),

    'password' => env('DB_PASSWORD', ''),

    'charset' => 'utf8',

    'collation' => 'utf8_unicode_ci',

    'prefix' => '',

    'strict' => true,

    'engine' => null,

    'modes'  => [

        'ONLY_FULL_GROUP_BY',

        'STRICT_TRANS_TABLES',

        'NO_ZERO_IN_DATE',

        'NO_ZERO_DATE',

        'ERROR_FOR_DIVISION_BY_ZERO',

        'NO_ENGINE_SUBSTITUTION',

        ],

],

answered yesterday

ingafter60

New contributor

This codes work for me. Thanks.

'mysql' => [

    'driver' => 'mysql',

    'host' => env('DB_HOST', 'localhost'),

    'port' => env('DB_PORT', '3306'),

    'database' => env('DB_DATABASE', 'forge'),

    'username' => env('DB_USERNAME', 'forge'),

    'password' => env('DB_PASSWORD', ''),

    'charset' => 'utf8',

    'collation' => 'utf8_unicode_ci',

    'prefix' => '',

    'strict' => true,

    'engine' => null,

    'modes'  => [

        'ONLY_FULL_GROUP_BY',

        'STRICT_TRANS_TABLES',

        'NO_ZERO_IN_DATE',

        'NO_ZERO_DATE',

        'ERROR_FOR_DIVISION_BY_ZERO',

        'NO_ENGINE_SUBSTITUTION',

        ],

],

answered yesterday

ingafter60

New contributor

answered yesterday

ingafter60

New contributor

answered yesterday

ingafter60

answered yesterday

ingafter60

New contributor

ingafter60 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Xtykutl