• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to connect remotely to mysql using mysql work bench on ubuntu  RSS feed

 
Megha Singhal
Ranch Hand
Posts: 225
IBM DB2 Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
mysql database is on another machine and i need to access the data on the computer using mysql workbench on ubuntu os and i don't have complete privilege of ubuntu . i try establish connection using manage connection on mysql workbench but still unable to establish the connection.
kindly provide me the steps to connect to the mysql database remotely.
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tell us how you are trying to to establish the connection, in particular all the connection parameters you're using, and what exactly happens when you do that.
 
Richard Tookey
Bartender
Posts: 1166
17
Java Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I access a remote MySQL using Work Bench by using an SSH tunnel which means that MySQL only has to be configured for local operations. Of course it does mean I needed to install an SSH server on the machine running MySQL but I need SSH running anyway for maintenance.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!