Worldskills 2024
Menu
Deployment
EC2
ECR
EKS
Serverless
Other
Utility
Best Practices
Home
CLI
lambda
0 Clicks
mysql install
Copy
sudo wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm sudo dnf install mysql80-community-release-el9-1.noarch.rpm -y sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 sudo dnf install mysql-community-client -y sudo dnf install mysql-community-server -y
mysql example
Copy
CREATE USER 'hasher'@'%' IDENTIFIED BY '63b4v90a8qzb63v4qaz890j'; CREATE DATABASE hashes; USE hashes; CREATE TABLE hashes ( id varchar(256), hash varchar(256) ); GRANT ALL PRIVILEGES ON hashes TO 'hasher'@'%';
postgresql install
Copy
sudo dnf install postgresql15.x86_64 postgresql15-server -y psql -h <host_name> -U postgres -W
postgresql example
Copy
CREATE USER myuser WITH PASSWORD 'password'; CREATE DATABASE cloudraiser; GRANT ALL PRIVILEGES ON DATABASE cloudraiser TO myuser; \c cloudraiser myuser CREATE TABLE hashes ( id VARCHAR(256), hash VARCHAR(256) );