備忘 MariaDB/MySQL 操作步驟

系統:ubuntu 16.04


Reset root password on Calera Cluster MariaDB(20180608)

忘記mysql root 密碼時的做法如下:
設定skip-grant-tables

然後再把skip-grant-table拿掉

重新restart mysql即可…


Calera Clustea MariaDB not sync(20180508)

Q: calera cluster mariadb not sync other server!!

A:

輸入指令重置/var/lib/mysql 和刪除/var/lib/mysql/grastate.dat

然後重新mysql服務即可

參考:https://serverfault.com/questions/812719/mysql-mariadb-not-starting