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

Recommended Answers

You can't do that, if you do not have Access.

Jump to Post

All 3 Replies

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.