CODEWITHSUNDEEP
mysql
System
System

Reputation: 315

How to whitelist IP addresses in MySQL Workbench?

Trying to follow this guide (https://developers.google.com/apps-script/guides/jdbc) to send Google Form responses to a local MySQL server. I have no idea how to whitelist IP addresses inside MySQL Workbench. I already tried googling, and going through the workbench documentation, but can't find anything.

How do I whitelist IP addresses that can connect to my local MySQL database in Workbench? This is MySQL 5.7.

Upvotes: 0

Views: 9764

Answers (1)

Adam Davis
Adam Davis

Reputation: 380

One way to accomplish this is through the Users and Privileges options menu, which can be accessed through the Server dropdown in MySQL Workbench. Through this menu you will be able to set the allowed host for a given user who can be configured to have whatever type of database access you need.

See link for more info https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html

Upvotes: 1

Related Questions