Mysql

mySQL commands

Restart mySQL service

• sudo systemctl restart mysql

Show databases

• mysql show databases

Enable Remote access

Check config file:

• sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Change bind-address from 127.0.0.1 (local host) to 0.0.0.0 to allow all ip addresses access