Control Panel Installation issue with MySQL

Read 11401 times
On the initial screen for the Administrator Account and MySQL Database stuff, when I click Next, I get the following error in red just above the Administration Account stuff:

Error populating database: Could not execute query: BLOB, TEXT, GEOMETRY or JSON column 'ignoremeta' can't have a default value

What do I need to do to fix this since I cannot proceed?
On the initial screen for the Administrator Account and MySQL Database stuff, when I click Next, I get the following error in red just above the Administration Account stuff:

Error populating database: Could not execute query: BLOB, TEXT, GEOMETRY or JSON column 'ignoremeta' can't have a default value

What do I need to do to fix this since I cannot proceed?

set sql_mode as below:
sql_mode='MYSQL40'
Hello there,

Where do we do the command you specify. Could you please give me some information?   :'(



On the initial screen for the Administrator Account and MySQL Database stuff, when I click Next, I get the following error in red just above the Administration Account stuff:

Error populating database: Could not execute query: BLOB, TEXT, GEOMETRY or JSON column 'ignoremeta' can't have a default value

What do I need to do to fix this since I cannot proceed?

set sql_mode as below:
sql_mode='MYSQL40'