如標題
遇到 ERROR
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Uses event mutexes
[Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using SSE2 crc32 instructions
[Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: 128 out of 128 rollback segments are active.
[Note] InnoDB: Creating shared tablespace for temporary tables
[Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
[Note] InnoDB: Waiting for purge to start
[Note] InnoDB: 10.4.10 started; log sequence number 113890; transaction id 9
[Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
[Note] Plugin 'FEEDBACK' is disabled.
[Note] InnoDB: Buffer pool(s) load completed at 191218 17:07:02
[Note] Server socket created on IP: '::'.
解決方式
方法1:
https://shreepaudel.com.np/mysql-wont-run-when-i-am-using-xampp-server/
說明: 想說系統還在測試關閉一下重開，結果就GG了 why....，
找了一下解決方法就是把 xampp/mysql/backup/ 底下所有檔案，複製取代到xampp/mysql/data/ ...
應該就可以啟動了....
方法2:
从控製面板打開shell並使用以下命令啟動mysql：
mysqld –-console –-skip-grant-tables –-skip-external-locking
使用此命令从控製面板打開另一个shell並修複資料庫：
mysqlcheck -r --databases mysql --use-frm
停止mysql，關闭shell並正常重啟mysql。
參考來源
https://t.codebug.vip/questions-25483.htm
方法3:
另外一種說法是，需要使用 右鍵 => 系統管理員權限=>>執行XAMPP
========================
類似 mysql原生資料庫重置，所以你 root密碼會被 reset 成 "空白".... 想改密碼怎麼辦?
用 heidisql 進入..mysql https://www.heidisql.com/download.php?download=portable-64
我用的是瑪利亞DB(MariaDB).... 更改密碼的SQL換了
https://www.techgalery.com/2019/09/error-1348-column-password-is-not.html
舊版mysql 密碼更改方式
UPDATE mysql.user SET Password=PASSWORD('666') WHERE User='root';
flush privileges;
新版 mysql (瑪麗亞DB) 密碼更改方式
ALTER USER 'root'@'localhost' IDENTIFIED BY '666';
flush privileges;
參考來源
https://shreepaudel.com.np/mysql-wont-run-when-i-am-using-xampp-server/
https://www.techgalery.com/2019/09/error-1348-column-password-is-not.html
以上文章僅用紀錄資料使用.....
