You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
mysql> CREATE USER 'holberton_user'@'localhost' IDENTIFIED BY 'projectcorrection280hbtn';
mysql> GRANT REPLICATION CLIENT ON *.* to 'holberton_user'@'localhost';
mysql> FLUSH PRIVILEGES;
2. If only you could see what I've seen with your eyes
mysql> CREATE DATABASE tyrell_corp;
mysql> USE tyrell_corp;
mysql> CREATE TABLE nexus6 (id INT, name VARCHAR(256));
mysql> INSERT INTO nexus6 (id, name) VALUES ('1', 'Leon');
mysql> GRANT SELECT ON tyrell_corp.nexus6 TO 'holberton_user'@'localhost';
3. Quite an experience to live in fear, isn't it?
msql> CREATE USER 'replica_user'@'%' IDENTIFIED BY 'password';
mysql> GRANT SELECT ON mysql.user TO 'holberton_user'@'localhost';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'replica_user'@'%';
4. Setup a Primary-Replica infrastructure using MySQL