Mysql for mac 8.0.11 install#

You can then continue the install process and it works:Īs Drupal website states that Drupal 8.6 should work with MySQL 8.0, let’s try it 😉Īlso as the PDO Documentation states it ( here), the version before 7.1.16 will return errors even with mysql_native_password authentication method, so I update PHP to 7.1.18.īut don’t forget that currently no version of mysqlnd supports caching_sha2_password and if your account uses that authentication method you will get such error: +'sql_mode' => 'SET sql_mode = 'ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,ONLY_FULL_GROUP_BY'', 'sql_mode' => 'SET sql_mode = 'ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,ONLY_FULL_GROUP_BY'', To fix this, we need to modify some Drupal source code and remove it from the line 183 in core/lib/Drupal/Core/Database/Driver/mysql/Connection.php: $connection_options += [ SQL_MODE doesn’t allow anymore 'NO_AUTO_CREATE_USER' ( please check here for other similar changes) In my.cnf, please add those lines in section: character-set-server = utf8ĭefault_authentication_plugin = mysql_native_passwordĪnd you can change the authentication plugin for the account used for Drupal: mysql> ALTER USER drupal_web IDENTIFIED WITH 'mysql_native_password' BY 'drUp4l'

Mysql for mac 8.0.11 how to#

So by default, Drupal 8.5 is not compatible with MySQL 8.0 and it’s also written on this page:īefore we move forward and try on Drupal 8.6, let me show you how to configure MySQL to also work on Drupal 8.5. The first problem is related to the charset: We can use our browser and point it to the Drupal url and follow the installation procedure until we arrive to the database form: Mysql> alter user drupal_web default role drupal_site Īs you can see, I’m using the new ROLES feature added in MySQL 8. Mysql> create user drupal_web identified by 'drUp4l' Mysql> grant all on drupal8.* to drupal_site Then I create the drupal8 database and setup an account: mysql> create database drupal8 So let’s try it.įirst I install MySQL 8.0.11 and unpack Drupal 8.5.5 in the apache’s datadir. There is no notes about supporting MySQL 8.0. Drupal 8.5ĭrupal 8.5.5 is the latest available stable release from July 4th 2018. Now if you want to use MySQL 8.0 with a fresh new Drupal 8, let’s have a look how does that work. Now that MySQL 8.0 GA is out for almost 3 months, let’s see the status of how it’s integrated with Drupal, a very popular CMS using MySQL.įor people having already a Drupal site and that wants to upgrade to MySQL 8.0, please check this post.