Menu
when i try to update one table(GLOBAL_VARIABLES) from information_schema db,
i get an error :
Access denied for user 'root'@'localhost' to database 'information_schema'
Although I am root user with all privileges ,
how can i fix permission. ?
or how can i update this table ?
thanks.
473
Information_Schema are views and read-only. Yo can not update meta data about tables, only by modifying actual table with ALTER TABLE . If you do an ALTER TABLE you will have current timestamp in meta data.
Whenever you access phpMyAdmin for one of your databases, you will also see a database named - information_schema: It is created by default and allows you to retrieve metadata about the objects within a database. As it's crucial to have this database intact, there is no way of deleting or editing it.
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data dictionary and system catalog.
You can't currently change a user's privileges in the control panel, so to do so you need to use a command-line MySQL client like mysql . After you create a user in the cluster, connect to the cluster as doadmin or another admin user.
You can change the global variables using SET, and read them using SHOW.
See http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html for more info
139
The INFORMATION_SCHEMA database is a "pseudo database" containing server-generated views and as far as I know, contains only read-only data. If you need to alter a variable, you need to go the standard way, see Per's answer. From the mySQL manual:
INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.
More detailed info on GLOBAL_VARIABLES here.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
