Percona/MariaDB/MySQL

# start a PXC node with the specified donor

service mysql start --wsrep_sst_donor=nodeC

# reset password

sudo /etc/init.d/mysql stop
sudo mysqld_safe --skip-grant-tables &
mysql -u root

mysql> update mysql.user set password=password("new-password") where user=‘root‘;
mysql> flush privileges;

# grant

show grants;
show grants for ‘ssluser‘@‘%‘;

show privileges

# create user

create user ‘username‘@‘localhost‘ identified by ‘password‘;
grant all privileges on db_name.* to ‘username‘@‘localhost‘;

# view fields related to SSL

 select user,host,password,ssl_type,ssl_cipher,x509_issuer,x509_subject from mysql.user;

Percona/MariaDB/MySQL

标签：