My ISP at home uses a dynamic IP address. I'm trying to access a MySQL database at work. How can I connect to it (using MySQL Workbench)?
I could grant all privileges to
% so that any IP address will do, but I think this is NOT VERY SAFE. I don't know if granting privilege to my current IP Address will work.
If it does, it will still be tedious to grant privilege every time the IP changes.
Thanks in advance!