database - How can I change the maximum number of characters allowed for a column name in MySQL? -

i building app (javafx application) logic dependent on column names , table names of available database (which in mysql). fine long column names small enough. encountered major setback in module required column names quite long. came know mysql not allow column names larger 64 characters.

i've tried doing:

alter table information_schema.`columns` modify column column_name varchar(256); 

but i'm getting following error:

#1044 - access denied user 'root'@'localhost' database 'information_schema' 

root has highest privilege still not allowing me alter information_schema.

am doing wrong? there way?

or there other application (other mysql) can use (given gives above facility of changing maximum length of column name).