amazon-linux2-install-mysql-5.7.md

amazon-linux2-install-mysql-5.7.md

source: https://techviewleo.com/how-to-install-mysql-8-on-amazon-linux-2/

Download mysql-5.7 package

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm -y
sudo yum install mysql-community-server -y

Start mysqld service.

systemctl start mysqld

# and then get template for root
grep 'temporary password' /var/log/mysqld.log

---
## somethimg like that...
2020-08-12T17:25:34.992227Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: BEw-U?DV,7eO

And then connect to Mysql, reset root password.

# connect to mysql
mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY

Enable log-bin

https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html

systemctl stop mysqld

vim /etc/my.cnf
#add "log-bin=mysql-bin" and "server-id=1" below [mysqld] 
---
[mysqld]
log-bin=mysql-bin
server-id=1
---

systemctl restart mysqld

Connect mysql again check log-bin enable

mysql -uroot -p

mysql> show variables like "%log_bin%";
+---------------------------------+--------------------------------+
| Variable_name                   | Value                          |
+---------------------------------+--------------------------------+
| log_bin                         | ON                             |
| log_bin_basename                | /var/lib/mysql/mysql-bin       |
| log_bin_index                   | /var/lib/mysql/mysql-bin.index |
| log_bin_trust_function_creators | OFF                            |
| log_bin_use_v1_row_events       | OFF                            |
| sql_log_bin                     | ON                             |
+---------------------------------+--------------------------------+
6 rows in set (0.00 sec)