View source for Upgrading from MySQL 5.7 to MySQL 8.0

== Incompatible SQL modes ==

For MySQL 5.7, the installation instructions guided you to create <code>/etc/mysql/mysql.conf.d/convention_master.cnf</code> with the following contents:

    <code>[mysqld]</code>
    <code>sql-mode="NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"</code>

These may also have been placed directly within <code>/etc/mysql/mysql.conf.d/mysqld.cnf</code> or another configuration file; your installation may vary.


'''BEFORE beginning the MySQL upgrade process!!!'''
You must remove <code>NO_AUTO_CREATE_USER</code> from the list of SQL modes. This is not a valid mode in MySQL 8.0, and leaving it in place will cause the upgrade process to break! You should now have

    <code>[mysqld]</code>
    <code>sql-mode="NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"</code>



'''HELP! I didn't read the instructions and my installation is now broken!'''
Find and remove the incompatible SQL mode as mentioned above, then run <code>apt-get --fix-broken install</code>.



== Set the required options ==

'''AFTER''' the upgrade to MySQL 8.0 is finished, log into MySQL as the root user (you may try <code>sudo mysql</code>, or you may also try <code>mysql -u root -p</code>) and run the following query:

    <code>SET GLOBAL log_bin_trust_function_creators = 1;</code>


You should now be ready to run with MySQL 8.0.