首页 > 数据库技术 > 详细

Percona/MariaDB/MySQL

时间:2016-07-09 00:43:30      阅读:287      评论:0      收藏:0      [点我收藏+]

# 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-pxc
service mysql bootstrap-pxc
service mysql start --wsrep_new_cluster
service mysql start --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 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

原文:http://www.cnblogs.com/jeffreyf/p/percona-mariadb-mysql.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!