Welcome to FreeSoftwareServers Confluence Wiki

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

Then use netstat to confirm:

netstat -tulpn | grep 3306
tcp        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