<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • 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
    Chapter 4:  Database Administration 295 `.my.cnf' You may set the prompt option in any MySQL con guration le, in the mysql group.  For example: [mysql] prompt=(\u@\h) [\d]>\_ Command Line You may set the --prompt option on the command line to mysql.  For example: shell> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> Interactively You may also use the prompt (or \R) command to change your prompt inter- actively.  For example: mysql> prompt (\u@\h) [\d]>\_ PROMPT set to '(\u@\h) [\d]>\_' (user@host) [database]> (user@host) [database]> prompt Returning to default PROMPT of mysql> mysql> 4.8.3  mysqladmin, Administrating a MySQL Server A utility for performing administrative operations.  The syntax is: shell> mysqladmin [OPTIONS] command [command-option] command ... You  can  get  a  list  of  the  options  your  version  of  mysqladmin  supports  by  executing mysqladmin --help. The current mysqladmin supports the following commands: create databasename Create a new database. drop databasename Delete a database and all its tables. extended-status Gives an extended status message from the server. flush-hosts Flush all cached hosts. flush-logs Flush all logs. flush-tables Flush all tables. flush-privileges Reload grant tables (same as reload).
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    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