CODEWITHSUNDEEP
google-compute-engine
ADL
ADL

Reputation: 2856

MySQL Workbench & Google Compute Engine Connection

I have mysql installed in an instance of google compute engine. I am able to connect to it via the shell however I want to use the MySQL workbench.

Is it possible to connect to it? I cant seem to make a connection.

Any help is appreciated, Thanks!

Upvotes: 1

Views: 1082

Answers (3)

Marco
Marco

Reputation: 608

Be sure also to allow root connection from outside, modifying MySQL user table :

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'password';

Upvotes: 2

ADL
ADL

Reputation: 2856

SOehl's answer can be correct, however I did not comment. Instead i changed it to bind-address 0.0.0.0.

Upvotes: 0

SOehl
SOehl

Reputation: 417

Not sure if your shell is run local on host via ssh, so it's just a guess that your mysql Server is just accepting connections from localhost.

To change this open your my.cnf File (on Debian Systems saved in /etc/mysql/my.cnf) and comment the folloing Line:

change:

bind-address              =127.0.0.1

to:

#bind-address              =127.0.0.1

Upvotes: 3

Related Questions