備忘 MariaDB/MySQL 操作步驟

May 29, 2018 May 28, 2019 技術文章

系統：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

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 |

+------+-------------+

UPDATE user SET plugin=""; // without WHERE clause

UPDATE user SET passwor=PASSWORD("mys_passwd") WHERE user="root"

FLUSH PRIVILEGES;

然後再把skip-grant-table拿掉

重新restart mysql即可…

Q: calera cluster mariadb not sync other server!!

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

然後重新mysql服務即可

1	#mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql