Skip to content

Instantly share code, notes, and snippets.

@Ameen-Alam
Created December 29, 2021 11:08
Show Gist options
  • Save Ameen-Alam/ce7631c0aea19035f74ac00a5220071d to your computer and use it in GitHub Desktop.
Save Ameen-Alam/ce7631c0aea19035f74ac00a5220071d to your computer and use it in GitHub Desktop.
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment