MySQL became part of my skill set in 2014. After installation of any instance of MySQL Server in Production or Test environment 2nd most task for any DBA is to connect the Database from Remote. While i was new with MySQL it played with me a lot to do this task from remote machine. I hang over for 3 days and ask many ppl and search many site. Did telnet, ip-config, firewall et………….. but resolve my problem in easy through below process…
- 1st Grant Remote Permission on Database Server
- 2nd Configure Connection at client workbench to server
How to grant permission on Database Server?
GRANT ALL PRIVILEGES ON *.* TO 'suman'@'%' IDENTIFIED BY 'xxx@123';
Now come back to Client – pc or desktop where workbench client is installed.
Configure new connection like below…
Result is cool... connected to server from client