linux] mysqladmin 명령어

[펌] mysqladmin명령들 linux 2005/06/30 22:17 수정 삭제 http://blog.naver.com/wiggyz/80014559279 이 얼마나 살만한 세상인가 | ???? http://blog.naver.com/jacking/3481100 현재 할동중인 thread보기 mysqladmin -u root -p proc stat(=processlist) db 서버가 살아있는지 확인 mysqladmin -u root -p ping mysqladmin create [databasename] : Create a new database. mysqladmin drop [databasename] : Delete a database and all its tables. mysqladmin flush-hosts : Flush all cached hosts. mysqladmin flush-logs : Flush all logs. mysqladmin flush-tables : Flush all tables. mysqladmin flush-privileges : Reload grant tables (same as reload). mysqladmin kill [id(,id,...)]: Kill mysql threads. mysqladmin password : Set a new password. Change old password to new-password. mysqladmin reload : Reload grant tables. mysqladmin refresh : Flush all tables and close and open logfiles. mysqladmin shutdown : Take server down. mysqladmin slave-start : Start slave replication thread. mysqladmin slave-stop : Stop slave replication thread. mysqladmin version : Get version info from server.

[펌] mysqladmin명령들  linux  2005/06/30 22:17  수정  삭제
 http://blog.naver.com/wiggyz/80014559279


 이 얼마나 살만한 세상인가 | ????
 http://blog.naver.com/jacking/3481100
현재 할동중인 thread보기
mysqladmin -u root -p proc stat(=processlist)

db 서버가 살아있는지 확인
mysqladmin -u root -p ping

mysqladmin create [databasename] : Create a new database.
mysqladmin drop [databasename] : Delete a database and all its tables.
mysqladmin flush-hosts : Flush all cached hosts.
mysqladmin flush-logs : Flush all logs.
mysqladmin flush-tables : Flush all tables.
mysqladmin flush-privileges : Reload grant tables (same as reload).
mysqladmin kill [id(,id,...)]: Kill mysql threads.
mysqladmin password : Set a new password. Change old password to new-password.
mysqladmin reload : Reload grant tables.
mysqladmin refresh : Flush all tables and close and open logfiles.
mysqladmin shutdown : Take server down.
mysqladmin slave-start : Start slave replication thread.
mysqladmin slave-stop : Stop slave replication thread.
mysqladmin version : Get version info from server.