Upgrading from MySQL 5.7 to MySQL 8.0 - Revision history

Aloha at 02:01, 25 March 2023

2023-03-25T02:01:15Z

← Older revision		Revision as of 21:01, 24 March 2023
Line 1:		Line 1:
	== Incompatible SQL modes ==		== 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:		For MySQL 5.7, the installation instructions guided you to create <code>/etc/mysql/conf.d/convention_master.cnf</code> with the following contents:

	<code>[mysqld]</code>		<code>[mysqld]</code>

Rex at 14:58, 22 March 2023

2023-03-22T14:58:51Z

← Older revision		Revision as of 09:58, 22 March 2023
Line 5:		Line 5:
	<code>[mysqld]</code>		<code>[mysqld]</code>
	<code>sql-mode="NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"</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.		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.

Rex: Created page with "== Incompatible SQL modes == For MySQL 5.7, the installation instructions guided you to create `/etc/mysql/mysql.conf.d/convention_master.cnf` with the following contents: `[mysqld]` `sql-mode="NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"` These may also have been placed directly within `/etc/mysql/mysql.conf.d/mysqld.cnf` or another configuration file; your installation may..."

2023-03-22T14:58:31Z

Created page with "== 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..."

New page

== 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.