cd C:\Program Files\MySQL\MySQL Server 5.x\bin
start mysqld # 啟動
mysqladmin -u root shutdown # 停止
# 安裝服務(僅需一次)
mysqld --install
# 或 mysqld-nt --install
# 日常操作
net start mysql # 啟動
net stop mysql # 停止
也可用 services.msc 圖形介面管理。
service mysqld start
service mysqld stop
service mysqld restart
/etc/init.d/mysqld start
/etc/init.d/mysqld stop
/etc/init.d/mysqld restart
safe_mysqld & # 後台啟動
mysqladmin shutdown # 停止
systemctl start mysqld
systemctl stop mysqld
systemctl restart mysqld
systemctl enable mysqld # 開機自啟
mysqladmin -u root -p ping
# 輸出 "mysqld is alive" 即正常