标签为 "mysql常用工具" 的存档

MYSQL中常用的工具

1.myisampack(MyISAM表压缩工具)
  eg:myisampack t3(t3.myd)

2.mysqladmin(MySQL管理工具)
  mysqladmin和mysql客户端登陆后执行的一些功能非常类似!
  可以执行的命令:
create databasename      Create a new database
debug            Instruct server to write debug information to log
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 Change old password to new-password, MySQL 4.1 hashing.
old-password new-password Change old password to new-password in old format.
ping         Check if mysqld is alive
processlist     Show list of active threads in server
reload            Reload grant tables
refresh        Flush all tables and close and open logfiles
shutdown       Take server down
status        Gives a short status message from the server
start-slave          Start slave
stop-slave         Stop slave
variables          Prints variables available
version          Get version info from server
eg: /usr/bin/mysqladmin -u root -p shutdown
/usr/bin/mysqladmin -u root -p password new-password(该用户原来有密码)
/usr/bin/mysqladmin -u root password  new-password(该用户原来没有密码)
Feed