CentOS6 system MySQL Master-slave database replication configuration details (1/3)

View MySQL Port is open

netstat-tanl | grep 3306

MySQL User's authorization

Mysql-uroot-p

View the existing User authorization table

Select User,host,password from Mysql.user;

Test connection to other MySQL server

Mysql-uroot-p-h192.168.0.100

Authorized user user1, password 456 all permissions from 192.168.1.181 host access to all databases of this server.

Grant all on *.* to slave@192.168.1.181 identified by "123456";

Log on to a remote MySQL server

mysql-uslave-p123456-h192.168.1.180

View the current database

Select Database ();

View table Structure

DESC table1;

Open MySQL Bin-log

Vim/etc/my.cnf
[Mysqld]
Log-bin
Or

Log-bin=mysql-bin

Bin-log Save path-database Data folder root directory

/var/lib/mysql

Home 1 2 3 last