Percona/mariadb/mysql

# Restore a database from a dump. sql file

Mysql-h mdbec-db1-u Wpadmin-pwpadminpass wpdb </wpdb.sql

# Percona XtraDB Cluster Start commands

/etc/init.d/mysql bootstrap-pxcservice MySQL bootstrap----wsrep-cluster-address="  gcomm://"

# Start a PXC node with the specified donor

Service MySQL start--wsrep_sst_donor=nodec

# Reset Password

Sudo/etc/Init.d/MySQL Stopsudo mysqld_safe--Skip-grant-tables &Mysql-u rootmysql> UpdateMysql.User SetPassword=Password ("New-Password ")where User='Root'; MySQL>FlushPrivileges;

# Grant

 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  from MySQL. user;

Percona/mariadb/mysql