| 作業系統 | 啟動 | 停止 | 狀態 |
|---|---|---|---|
| Windows | net start mysql | net stop mysql | net help services |
| Linux | service mysqld start | service mysqld stop | service mysqld status |
net stop mysql
mysqld --skip-grant-tables &
mysql -u root
UPDATE mysql.user SET password=PASSWORD('新密碼') WHERE user='root';
FLUSH PRIVILEGES;
EXIT;
net start mysql
CREATE DATABASE openfire; GRANT ALL ON openfire.* TO openfire@localhost IDENTIFIED BY 'openfire'; FLUSH PRIVILEGES;
指定 IP 授權：GRANT ALL ON admin.* TO otalk@'172.17.100.156' IDENTIFIED BY 'password01!';
回收權限：REVOKE ALL PRIVILEGES ON admin.users FROM otalk@localhost;
[client] default-character-set=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci
重啟後驗證：
SHOW VARIABLES LIKE 'character_set_%'; SHOW VARIABLES LIKE 'collation_%';
均顯示 utf8 即生效。建表時建議顯式指定 CHARSET=utf8。
編輯 my.cnf，註釋掉：
# log-bin=mysql-bin # binlog_format=mixed
重啟服務即可恢復。長期建議：配置 expire_logs_days 自動清理，勿手動刪除。
