Mysql5.6
1、删除系统自带的mysql
rpm -qa|grep mysql
yum remove mysql-libs
2、安装mysql YUM源
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
或 wget http://repo.mysql.com/mysql57-community-release-el6.rpm
rpm-ivh mysql-community-release-el6-5.noarch.rpm
3、安装mysql
yum install mysql-server mysql-devel
4、root密码设置
service mysqld stop
mysqld_safe--skip-grant-tables &
mysql -u root -p 回车直接进去,或者随便输入一个密码
use mysql;
update user set password=PASSWORD("newpass")whereuser="root"; 更改密码为 newpassord
flushprivileges; 更新权限
quit
mysqladmin使用
1.例如你的 root用户现在没有密码,你希望的密码修改为123456,那么命令是:
mysqladmin -u root password 123456
2.如果你的root现在有密码了(123456),那么修改密码为abcdef的命令是:
mysqladmin -u root -p password abcdef
注意,命令回车后会问你旧密码,输入旧密码123456之后命令完成,密码修改成功。
grant命令
mysql>grant all privileges on testDB.* to test@localhost identified by '1234'; mysql>flush privileges;//刷新系统权限表 mysql>grant select,update on testDB.* to test@localhost identified by '1234'; mysql>flush privileges; //刷新系统权限表 mysql>grant select,delete,update,create,drop on *.* to test@"%" identified by "1234";
|
主从配置
Master
[liuhz@VM_224_105_centos ~]$ sudo cat/etc/my.cnf
[sudo] password for liuhz:
[mysqld]
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommendedto prevent assorted security risks
symbolic-links=0
log-bin=mysql-bin
server-id=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
[mysqld_safe]
log-error=/data/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
grant replication slave on *.* to repl_user@"%" identified by 'copypass'
show master status;
+------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000006 | 258 | | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) |
Slave
[liuhz@VM_35_103_centos ~]$ sudo cat /etc/my.cnf
[sudo] password for liuhz:
[mysqld]
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommendedto prevent assorted security risks
symbolic-links=0
server-id=2
[mysqld_safe]
log-error=/data/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
slave stop; change master to master_host = '10.131.224.105', master_user='repl_user',master_password='copypass',master_log_file='mysql-bin.000006',master_log_pos=258; start slave;
SHOW SLAVE STATUS\G |