MySQL Essentials
Login
Console
mysql -u root -p
Enter password: **********
mysql>Remote Login
Requires the mysql client (install mysql -y) & TCP 3306 to be open
mysql -u [user_name] -p -h [database.rds.amazonaws.com] [database_name]Databases
show databases;
use exampledatabase;Restore DB
mysql -u [user] -p [database_name] < [filename].sqlTables
show tables;
select * from wp_options
show global variablesRelated
- AWS Essentials
- Nano Essentials
- Hostapd Essentials
- IP Tables Essentials
- dnsmasq Essentials
- YAML Essentials
- chmod Essentials
- Home Assistant Essentials
- GIT Essentials
- Linux IP Essentials
- Linux Routing Essentials
- Portainer Essentials
- Ansible Essentials
- Pi Camera Essentials
- AirCrack NG Essentials
- SSH Tunneling Essentials
- PiHole Essentials
- Android Hardware Essentials
- dd Essentials
- Nextcloud Essentials
- Symbolic Link Essentials
- Grep Essentials
- UFW Essentials
- Rsync Essentials
- WireGuard Essentials
- Docker Essentials
- PinePhone Essentailas
- Ansible Vault Basics
Links
- https://www.mysql.com/
- https://hub.docker.com/_/mysql/