onprem-mysql

yum install wget -y 

 

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 

 

tar -xf mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 

 

yum yum localinstall mysql-community-* 

 

systemctl start mysqld.service && systemctl enable mysqld.service && systemctl status mysqld.service 

 

grep "A temporary password" /var/log/mysqld.log  DvY5pqNdqm/R 

 

----------------------------------------------------- 

mysql -h localhost -u root -p 

 

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Test?786'); 

UPDATE mysql.user SET host = '%' where User = 'root'; 

FLUSH PRIVILEGES; 

 

------------------------------------------------- 

####  Create user with all privileges. 

 

CREATE USER 'infinity'@'%' IDENTIFIED BY 'Infinity@123'; 

GRANT ALL PRIVILEGES ON *.* TO 'infinity'@'%'; 

FLUSH PRIVILEGES; 

select user,host from mysql.user; 

exit 

 

vi /etc/my.cnf 

 

server_id=1 

lower_case_table_names=2 

max_allowed_packet = 1G 

group_concat_max_len = 1G 

sql-mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 

 

## For AWS  

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'infinity'@'%' WITH GRANT OPTION;