Welcome to Linux Knowledge Base and Tutorial
"The place where you learn linux"
Linux Magazine

 Create an AccountHome | Submit News | Your Account  

Tutorial Menu
Linux Tutorial Home
Table of Contents

· Introduction to Operating Systems
· Linux Basics
· Working with the System
· Shells and Utilities
· Editing Files
· Basic Administration
· The Operating System
· The X Windowing System
· The Computer Itself
· Networking
· System Monitoring
· Solving Problems
· Security
· Installing and Upgrading
· Linux and Windows

Glossary
MoreInfo
Man Pages
Linux Topics
Test Your Knowledge

Site Menu
Site Map
FAQ
Copyright Info
Terms of Use
Privacy Info
Disclaimer
WorkBoard
Thanks
Donations
Advertising
Masthead / Impressum
Your Account

Communication
Feedback
Forums
Private Messages
Surveys

Features
HOWTOs
News Archive
Submit News
Topics
User Articles
Web Links

Google
Google


The Web
linux-tutorial.info

Who's Online
There are currently, 111 guest(s) and 0 member(s) that are online.

You are an Anonymous user. You can register for free by clicking here

  

mysqladmin




OPTION SYNOPSIS

       mysqladmin [-#|--debug= logfile] [-f|--force]  [-?|--help]
       [--character-sets-dir=directory]           [-C|--compress]
       [-h|--host=[#]] [-p[pwd]]  [--password=[pwd]]  [-P|--port=
       pnum]   [-i|--sleep=  sec]  [-E|--vertical]  [-s|--silent]
       [-S|--socket=   #]   [-r|--relative]   [-t|--timeout=   #]
       [-u|--user=     uname]    [-v|--verbose]    [-V|--version]
       [-w|--wait[=retries]]


OPTION DESCRIPTION

       You can get a list of the options your version of mysqlad­
       min supports by executing mysqladmin --help


OPTIONS

       -#|--debug=logfile
              Output debug log. Often this is 'd:t:o,filename`

       -f|--force
              Don't  ask  for confirmation on drop database; with
              multiple commands, continue even if an error occurs

       -?|--help
               Display help and exit

       --character-sets-dir=directory
              Set the character set directory

       -C|--compress
              Use compression in server/client protocol

       -h|--host=hostname
              Connect to host

       -p|--password[=pwd]
              Password  to use when connecting to server If pass­
              word is not given it's asked from the tty

       -P|--port=pnum
              Port number to use for connection

       -i|--sleep=sec
              Execute commands  again  and  again  with  a  sleep
              between

       -r|--relative
              Show difference between current and previous values
              when used with -i extended-status

       -E|--vertical
              Print output vertically. Is similar to  --relative,
              but prints output vertically.
              Write more information

       -V|--version
              Output version information and exit

       -w|--wait
                Wait and retry if connection is down


COMMAND SYNOPSIS

       MySQLADMIN  [create  databasename  ]  [drop  databasename]
       [extended-status]   [flush-hosts]   [flush-logs]   [flush-
       tables]  [flush-privileges]  [  kill id,id,... ] [password
       new-password ]  [ping]  [processlist]  [reload]  [refresh]
       [shutdown] [slave-start] [slave-stop] [status] [variables]
       [version]


COMMANDS

       Where command is a one or more of: (Commands may be short­
       ened)

       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-status
              Clear status variables

       flush-tables
              Flush all tables

       flush-threads
              Flush the thread cache

       flush-privileges
              Reload grant tables (same as reload)

       kill id,id,...
              Kill mysql threads

       password new-password

       status Gives a short status message from the server

       variables
              Prints variables available

       version
              Get version info from server


SEE ALSO

       isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1),
       mysqlbug (1), mysqld (1), mysqldump  (1),  mysqlshow  (1),
       msql2mysql  (1), perror (1), replace (1), mysqld_safe (1),
       which1 (1), zap (1),


AUTHOR

       Ver 1.0, distribution 3.23.29a  Michael  (Monty)  Widenius
       (monty@tcx.se),  TCX  Datakonsult  AB (http://www.tcx.se).
       This software comes with no warranty.  Manual page  by  L.
       (Kill-9)  Pedersen  (kill-9@kill-9.dk),  Mercurmedia  Data
       Model Architect / system  developer  (http://www.mercurme­
       dia.com)

MySQL 4.0                19 December 2000           mysqladmin(1)
  




Login
Nickname

Password

Security Code
Security Code
Type Security Code


Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.

Help if you can!


Amazon Wish List

Did You Know?
You can get all the latest Site and Linux news by checking out our news page.


Friends



Tell a Friend About Us

Bookmark and Share



Web site powered by PHP-Nuke

Is this information useful? At the very least you can help by spreading the word to your favorite newsgroups, mailing lists and forums.
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters. Articles are the property of their respective owners. Unless otherwise stated in the body of the article, article content (C) 1994-2013 by James Mohr. All rights reserved. The stylized page/paper, as well as the terms "The Linux Tutorial", "The Linux Server Tutorial", "The Linux Knowledge Base and Tutorial" and "The place where you learn Linux" are service marks of James Mohr. All rights reserved.
The Linux Knowledge Base and Tutorial may contain links to sites on the Internet, which are owned and operated by third parties. The Linux Tutorial is not responsible for the content of any such third-party site. By viewing/utilizing this web site, you have agreed to our disclaimer, terms of use and privacy policy. Use of automated download software ("harvesters") such as wget, httrack, etc. causes the site to quickly exceed its bandwidth limitation and are therefore expressly prohibited. For more details on this, take a look here

PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.09 Seconds