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
  • 103 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by rami1234
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.