Another one I have to keep rediscovering, so I decided to just document it and know where to look for it.
Trying to connect remotely to the MySQL instance of my Virtual Linux node I got the
"Host 'cpe-76-181-242-18.columbus.res.rr.com' is not allowed to connect to this MySQL server".
Solution was to log in to mysql as a root and create that particular user for that particular hostname:
mysql -u<yourRootId> -p<password>;
CREATE USER 'someuser'@'cpe-76-181-242-18.columbus.res.rr.com' IDENTIFIED BY 'some_P@ssw0rd';
GRANT ALL PRIVILEGES ON *.* TO 'someuser'@'cpe-76-181-242-18.columbus.res.rr.com';
In some cases you may have to also do
for the changes to take effect.
Hope this helps someone. Cheers!
P.S. No worries, the hostnames are made up.