Fulltext results:
- mySQL
- t by mail: mysqlcheck -A -r --host=${HOST} --user=root --port=3308 \ --password=${PASSWD} | mai... t --host=127.0.0.1 --default-character-set=utf8 --user=root --password=${PWD} $DB > $FILE If you get "... ass in SQL: mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> qui
- Replication @linux:databases:mysql
- ysql -u root --password=xxxx **Add a replication user on both nodes:** GRANT REPLICATION SLAVE ON ... CHANGE MASTER TO MASTER_HOST='1.2.3.4', MASTER_USER='replicator', MASTER_PASSWORD='xyxyxyxyxyxyxyxyxy... CHANGE MASTER TO MASTER_HOST='1.2.3.4', MASTER_USER='replicator', MASTER_PASSWORD='xyxyxyxyxyxyxyxyxy