Member Avatar for arunthangavel

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

  • 3 Contributors
  • 3 Replies
  • 102 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by rami1234

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

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

Member Avatar for arunthangavel

Hi

How to grant access for updating the table GLOBAL_VARIABLES IN the database information_schema

Member Avatar for rami1234

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.