SpirirHost Support Centre: MySQL Reference Manual p.202

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

202 MySQL Technical Reference for Version 4.0.3 SUPER kill The reload command tells the server to re-read the grant tables. The refresh command ushes all tables and opens and closes the log les. flush-privileges is a synonym for reload. The other flush-* commands perform functions similar to refresh but are more limited in scope, and may be preferable in some instances. For example, if you want to ush just the log les, flush-logs is a better choice than refresh. The shutdown command shuts down the server. The processlist command displays information about the threads executing within the server. The kill command kills server threads. You can always display or kill your own threads, but you need the PROCESS privilege to display and SUPER privilege to kill threads initiated by other users. See Section 4.5.5 [KILL], page 250. It is a good idea in general to grant privileges only to those users who need them, but you should exercise particular caution in granting certain privileges: The GRANT privilege allows users to give away their privileges to other users. Two users with dierent privileges and with the GRANT privilege are able to combine privileges. The ALTER privilege may be used to subvert the privilege system by renaming tables. The FILE privilege can be abused to read any world-readable le on the server into a database table, the contents of which can then be accessed using SELECT. This includes the contents of all databases hosted by the server! The SHUTDOWN privilege can be abused to deny service to other users entirely, by ter- minating the server. The PROCESS privilege can be used to view the plain text of currently executing queries, including queries that set or change passwords. Privileges on the mysql database can be used to change passwords and other access privilege information. (Passwords are stored encrypted, so a malicious user cannot simply read them to know the plain text password.) If they can access the mysql.user password column, they can use it to log into the MySQL server for the given user. (With sucient privileges, the same user can replace a password with a dierent one.) There are some things that you cannot do with the MySQL privilege system: You cannot explicitly specify that a given user should be denied access. That is, you cannot explicitly match a user and then refuse the connection. You cannot specify that a user has privileges to create or drop tables in a database but not to create or drop the database itself. 4.2.8 Connecting to the MySQL Server MySQL client programs generally require that you specify connection parameters when you want to access a MySQL server: the host you want to connect to, your user name, and your password. For example, the mysql client can be started like this (optional arguments are enclosed between `[' and `]'): shell> mysql [-h host_name] [-u user_name] [-pyour_pass]

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