PXC

Configuring Nodes for Write-Set Replication

https://www.percona.com/doc/percona-xtradb-cluster/LATEST/configure.html

CentOS 7 安装Percona 5.7，Xtrabackup

https://www.cnblogs.com/liushen/p/5715546.html

查看MySQL初始密码

cat /var/log/mysqld.log | grep "A temporary password"

修改MySQL密码

mysql_secure_installation

创建远程管理员账户

mysql -u root -p

 

mysql> CREATE USER 'sstuser'@'localhost' IDENTIFIED BY 'passw0rd';
mysql> GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO
  'sstuser'@'localhost';

GRANT all privileges ON *.* TO 'admin'@'%';

mysql> FLUSH PRIVILEGES;

https://www.cnblogs.com/kerrycode/p/6933024.html

转载于:https://my.oschina.net/u/3934842/blog/3056582