Hi All ,
I tried to update the field RANGE_ALLOC_BLOCK_SIZE in table GLOBAL_VARIABLES of information_schema database.But i face the error Access denied for the root user.Can anyone help me to update the field.
Thanks,
Arun T
Hi All ,
I tried to update the field RANGE_ALLOC_BLOCK_SIZE in table GLOBAL_VARIABLES of information_schema database.But i face the error Access denied for the root user.Can anyone help me to update the field.
Thanks,
Arun T
Jump to PostYou can't do that, if you do not have Access.
You can't do that, if you do not have Access.
Hi
How to grant access for updating the table GLOBAL_VARIABLES IN the database information_schema
you can't update any values in information_schema database because the information in this database if from the server it self or the data dictionary for the server and database , if you want to update this value the right way is not to update it , you shout use set global [variable name] = value , then restart mysql engine the the value will be updated in information_schema database automatically
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.