Need to allow remote access of mysql from another server.
(1) remote access of mysql.
This will be measured complete when user can successfully execute the following two (2) commands from the local server command line:
mysql -h'IP_ADDRESS' -u'USER' -p'PASSWORD' , then 'SHOW TABLES'
A short (1-2 paragraph) description of what had to occur in order to perform deliverable (1).
-updated port, skip-external-locking and bind-address in and in my.cnf to ...
-executed iptables ...
-set user X permissions in mysql by executing:
update user set Host='18.104.22.168' where user='webadmin';
GRANT ALL ON foo.* TO bar@'22.214.171.124' IDENTIFIED BY 'PASSWORD';
Access will be via PUTTY: ip, login and details will be provided upon award and acceptance of contract.
Payment will be awarded upon completion of the above 2 deliverables and a successful IA