mysql

 

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