I am having a bit of trouble accessing my database remotely from my home pc in mysql workbench.
Steps: Set the bind address to 0.0.0.0 in mysqld.cnf GRANT ALL ON . TO ‘userName’@‘localhost’; GRANT ALL ON . TO ‘userName’@‘%’; flush privileges; 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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
