SpirirHost Support Centre: MySQL Reference Manual p.200

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

200 MySQL Technical Reference for Version 4.0.3 The tables_priv and columns_priv tables are similar to the db table, but are more ne-grained: they apply at the table and column levels rather than at the database level. Note that administrative privileges (RELOAD, SHUTDOWN, etc.) are specied only in the user table. This is because administrative operations are operations on the server itself and are not database-specic, so there is no reason to list such privileges in the other grant tables. In fact, only the user table need be consulted to determine whether you can perform an administrative operation. The FILE privilege is specied only in the user table, too. It is not an administrative privilege as such, but your ability to read or write les on the server host is independent of the database you are accessing. The mysqld server reads the contents of the grant tables once, when it starts up. Changes to the grant tables take eect as indicated in Section 4.3.3 [Privilege changes], page 217. When you modify the contents of the grant tables, it is a good idea to make sure that your changes set up privileges the way you want. For help in diagnosing problems, see Section 4.2.11 [Access denied], page 208. For advice on security issues, see Section 4.2.2 [Security], page 194. A useful diagnostic tool is the mysqlaccess script, which Yves Carlier has provided for the MySQL distribution. Invoke mysqlaccess with the --help option to nd out how it works. Note that mysqlaccess checks access using only the user, db and host tables. It does not check table- or column-level privileges. 4.2.7 Privileges Provided by MySQL Information about user privileges is stored in the user, db, host, tables_priv, and columns_priv tables in the mysql database (that is, in the database named mysql). The MySQL server reads the contents of these tables when it starts up and under the circum- stances indicated in Section 4.3.3 [Privilege changes], page 217. The names used in this manual to refer to the privileges provided by MySQL version 4.0.2 are shown here, along with the table column name associated with each privilege in the grant tables and the context in which the privilege applies: Privilege Column Context ALTER Alter_priv tables DELETE Delete_priv tables INDEX Index_priv tables INSERT Insert_priv tables SELECT Select_priv tables UPDATE Update_priv tables CREATE Create_priv databases, tables, or indexes DROP Drop_priv databases or tables GRANT Grant_priv databases or tables REFERENCES References_ priv databases or tables

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide