#启动mysql服务service mysqld start
#初始化mysql用户root的密码
./bin/mysqladmin -uroot -p'4cSM((-qlNz-' password 'root'#4cSM((-qlNz-为上面初始化mysql生成的随机密码#输入密码进入
mysql -uroot -p
#mysql远程授权#输入密码进入
mysql -uroot -p
grant all privileges on *.* to 'root'@'%' identified by 'root';
FLUSH PRIVILEGES;#开放端口vim /etc/sysconfig/iptables
-A INPUT -p tcp -m multiport --dports 3306 -j ACCEPT
service iptables restart
主从配置
主配置
cd /data/app/mysql-5.7.16/
#修改配置vim my.cnf
port =3306
server_id =1#服务id,一般为ip后三位
binlog-do-db = beyond #要同步的数据库#binlog-ignore-db = mysql,sys,information_schema,performance_schema #不用同步的数据库,多个以逗号分隔
log-bin = mysql-bin #开启log-bin#其他配置优化
max_binlog_size = 500M
binlog_cache_size = 2M
max_binlog_cache_size = 4M
expire_logs_days =30
max_connections =500
max_connect_errors =10000
table_open_cache =256
long_query_time =1
slow-query-log
#慢sql打印
slow_query_log_file = /data/datas/mysql/data/slow_query_log_file.log
#重启service mysqld restart
#创建一个主从同步的用户
mysql -uroot -p
create user 'repl'@'%' identified by '123456';#授权
grant replication slave on *.* to 'repl'@'%' identified by '123456';
flush privileges;
show master status;#查看状态