Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

Both services require editing configuration to set "bind-address = 0.0.0.0"

Then use netstat to confirm:

netstat -tulpn | grep 3306
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      157544/mysqld

Use mysql to confirm:

Note: If you try to connect using your local IPv4 address is "simulates" remote access

Create SuperUser

HOSTIP="$(ip -4 addr show eth0 | grep -oP '(?<=inet\s)\d+(\.\d+){3}')"
mysql -h $HOSTIP -u SuperUserName -pSuperUserPass
mysql -h localhost -u SuperUserName -pSuperUserPass
  • No labels