User Insert Not Compatible with 5.7

[anton-dealmeida]

HOWTO-Install-and-Configure-Shibboleth-Identity-Provider/shibboleth-db.sql

Line 39 in 683ff97

INSERT INTO user (Host, User, Password, Select_priv,Insert_priv,Update_priv, Delete_priv, Create_tmp_table_priv, Lock_tables_priv,Execute_priv) VALUES ('localhost','idem',PASSWORD('demo'),'Y','Y','Y','Y','Y','Y','Y');

With the release of MySQL 5.7 the Password column was removed and is now known as authentication_string.
There are also a lot of new required columns, ssl_cipher, x509_issuer, x509_subject, etc...
Is this the best way to add the user?

[malavolti]

Thank you!

What changes do you suggest to do the same in the right way?