Debian10中安装mysql的过程

Debian10中安装mysql的过程

下载mysql官方的debian的apt下载源

wget dev.mysql.com/get/mysql-a…

安装 mysql官方的debian的apt下载源

sudo apt-get install ./mysql-apt-config_0.8.24-1_all.deb

更新 apt 源

sudo apt-get update

安装mysql服务

sudo apt-get install mysql-server

mysql 开放第三方ip访问的办法

mysql -u root -p

use mysql

update user set host='%' where user ='root';

FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;

在主库上做设置

create user 'backup'@'%' IDENTIFIED BY 'backup';

grant file on . to 'backup'@'%';

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON . to 'backup'@'%';

flush privileges;

在从服务器上设置

stop slave;

CHANGE MASTER TO master_host = '192.168.1.201', master_port = 3306, master_user = 'root', master_password = '123456', master_log_file = 'mysql-bin.000001', master_log_pos = 1073;

start slave