MySQL/README.md

# MySQL

Heyo is a Hello World for MySQL

***

MySQL Filetypes | .sql | .cvs

## Install
```bash
sudo apt install mysql-server -y
```

## IMPORTANT
The default install of MySQL on Ubuntu/Debain are NOT super secure... Yes the ip.port is blocked to local connections by default but if your SSH get pops any user with sudo can have root to your mysql as well... so to fix that run this command. You may want to lock mysql down AFTER you've configed mysql for your projects needs.
```bash
sudo mysql_sercure_installation
```

### Enable remote connections
Perfect for managing databases remotely, enable mysql on the firewall `ufw allow mysql` and then alter `sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf` and alter
```
. . .
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 0.0.0.0
. . .
```