Error inserting host: Field 'authentication_string' doesn't have a default value


Enter Your Query:
Use '%' for wildcards and quotes for "exact phrases"


Top Level » MySQL / MariaDB

Error inserting host: Field 'authentication_string' doesn't have a default valueLast Modified: Jan 25, 2018, 11:09 pm
Update January 25, 2018:
An actual fix has been added to check for, and explicitly set the blank authentication_string value when adding an access host.
https://www.directadmin.com/features.php?id=2083



old

Design change in MariaDB 10.2.x where DA is not specify a value for the authentication_string, when a host is set.
It might throw this error:

Error inserting host: Field 'authentication_string' doesn't have a default value

As a workaround, we can set a default value with this call SQL command:

ALTER TABLE mysql.user ALTER authentication_string SET DEFAULT '';

Run that sql in phpMyAdmin as the da_admin or root mysql Users.

Do not confuse this with MySQL 5.7, which uses the authentication_string to fully replace the password column.
For that, you'd tell DA to use mysql_milestone_16=1

© 2018 JBMC Software, Suite 173  3-11 Bellerose Drive, St Albert, AB  T8N 1P7  Canada.  Mon-Fri 9AM-5PM MST