Seems SQL syntax highlighter has bug
Answered
MySQL 8 syntax
CREATE
USER IF NOT EXISTS 'test'@'%'
IDENTIFIED WITH sha256_password BY '123456'
DEFAULT ROLE 'test'
REQUIRE NONE
WITH MAX_QUERIES_PER_HOUR 10000
MAX_UPDATES_PER_HOUR 10000
MAX_CONNECTIONS_PER_HOUR 5
MAX_USER_CONNECTIONS 1
PASSWORD EXPIRE INTERVAL 30 DAY
PASSWORD HISTORY 10
PASSWORD REUSE INTERVAL 360 DAY
PASSWORD REQUIRE CURRENT
-- FAILED_LOGIN_ATTEMPTS 3
-- PASSWORD_LOCK_TIME 7
ACCOUNT LOCK
Please sign in to leave a comment.
Hello,
Thanks for the report.
I created issue on YouTrack: https://youtrack.jetbrains.com/issue/DBE-18105/False-error-highlighting-with-MySQL-8-syntax
Please follow it for updates.