SpirirHost Support Centre: MySQL Reference Manual p.222

<< 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

222 MySQL Technical Reference for Version 4.0.3 databases, but only when accessed from the proper hosts. As usual, when the grant tables are modied directly, the server must be told to reload them (with FLUSH PRIVILEGES) so that the privilege changes take eect. If you want to give a specic user access from any machine in a given domain, you can issue a GRANT statement like the following: mysql> GRANT ... -> ON *.* -> TO myusername@"%.mydomainname.com" -> IDENTIFIED BY 'mypassword'; To do the same thing by modifying the grant tables directly, do this: mysql> INSERT INTO user VALUES ('%.mydomainname.com', 'myusername', -> PASSWORD('mypassword'),...); mysql> FLUSH PRIVILEGES; You can also use xmysqladmin, mysql_webadmin, and even xmysql to insert, change, and update values in the grant tables. You can nd these utilities in the Contrib directory of the MySQL web site (http://www.mysql.com/Downloads/Contrib/). 4.3.6 Limiting user resources Starting from MySQL 4.0.2 one can limit certain resources per user. So far, the only available method of limiting usage of MySQL server resources has been setting the max_user_connections startup variable to a non-zero value. But this method is strictly global and does not allow for management of individual users, which could be of particular interest to Internet Service Providers. Therefore, management of three resources is introduced on the individual user level: Number of all queries per hour: All commands that could be run by a user. Number of all updates per hour: Any command that changes any table or database. Number of connections made per hour: New connections opened per hour. A user in the aforementioned context is a single entry in the user table, which is uniquely identied by its user and host columns. All users are by default not limited in using the above resources, unless the limits are granted to them. These limits can be granted only via global GRANT (*.*), using this syntax: GRANT ... WITH MAX_QUERIES_PER_HOUR N1 MAX_UPDATES_PER_HOUR N2 MAX_CONNECTIONS_PER_HOUR N3; One can specify any combination of the above resources. N1, N2 and N3 are integers and stands for count / hour. If user reaches any of the above limits withing one hour, his connection will be terminated or refused and the appropriate error message shall be issued. Current usage values for a particular user can be ushed (set to zero) by issuing a GRANT statement with any of the above clauses, including a GRANT statement with the current values.

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