[MYSQL] XAMPP MYSQL ERROR Server socket created on IP: ‘::’

如標題

遇到 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: '::'.
 

解決方式   

https://shreepaudel.com.np/mysql-wont-run-when-i-am-using-xampp-server/ 

說明: 想說系統還在測試關閉一下重開,結果就GG了  why....,

找了一下解決方法就是把 xampp/mysql/backup/ 底下所有檔案,複製取代到xampp/mysql/data/ ...

應該就可以啟動了....如果還是不行,請找其他方式吧QQ

 

類似 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  

https://www.heidisql.com/

 

 

以上文章僅用紀錄資料使用.....