Aller au contenu

MySql#

Requete a partir de la ligne commande#

AWS Reference

Installing MySQL on Amazon Linux 2023#

Bash
1
2
3
# In sudo mode
dnf install mariadb105
mysql --version

Installing MySQL on Amazon Linux 2#

Bash
1
2
3
# In sudo mode
yum install mariadb
mysql --version

Installing MySQL on Debian#

Bash
1
2
3
# In sudo mode
apt install mariadb-client
mysql --version

Init Varibles#

Bash
1
2
3
4
export HOST=db-hostname.ca-central-1.rds.amazonaws.com
export PORT=3306
export USER=dev
export PASSWORD='asdfghjl1234@#$'

Connect#

Bash
1
mysql -h $HOST -P $PORT -u $USER -p $PASSWORD

Commands#

SQL
1
2
3
4
5
SHOW DATABASES;

USE db_name;

SELECT * FROM....