系統：ubuntu 16.04
Table of Contents ->
Reset root password on Calera Cluster MariaDB(20180608)
忘記mysql root 密碼時的做法如下：
設定skip-grant-tables
1 | $ sudo mysqld_safe --skip-grant-tables & |
1 | $ vi /etc/mysql/my.conf |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | add skip-grant-tables restart mysql: server mysql restart execute update sql: mysql>use mysql; MariaDB [mysql]>; SELECT user, plugin FROM user; +------+-------------+ | user | plugin | +------+-------------+ | root | unix_socket | | root | unix_socket | | root | unix_socket | | root | unix_socket | +------+-------------+ UPDATE user SET plugin=""; // without WHERE clause UPDATE user SET passwor=PASSWORD("mys_passwd") WHERE user="root" FLUSH PRIVILEGES; |
然後再把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服務即可
1 | #mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql |
參考：https://serverfault.com/questions/812719/mysql-mariadb-not-starting