Remote DB Access
I am having a bit of trouble accessing my database remotely from my home pc in mysql workbench.
Set the bind address to 0.0.0.0 in mysqld.cnf
GRANT ALL ON . TO ‘userName’@'localhost’;
GRANT ALL ON . TO 'userName’@’%’;
sudo /etc/init.d/mysql restart
In the db my user appears with a % under host meaning they have remote access but I still get access denied for 'userName’@'localhost’ in workbench.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×