I install the plugin on the site for registration in Russian(Allow Cyrillic Usernames) and now I need to change in the sql database, in the table wp_users, in the column user_nicename permission to write more characters from by default 50 to 255. How to do this? Tried, did not work: ALTER TABLE wp_users ALTER COLUMN user_nicename varchar(200) NOT NULL -error
user_nicename VARCHAR(255) NOT NULL DEFAULT ''; -error #1067
Found in net tip:
show variables like 'sql_mode' ;
And remove the sql_mode "NO_ZERO_IN_DATE,NO_ZERO_DATE" to make it work.
How to do this one?