Conectare la MySQL printr-un tunel SSH in Windows

postat acum 4 ani de Stefanescu Mihai in categorie iNoob

In acest articol am sa va invat sa va conectati la baza de date MySql (de pe un server) folosind SSH si un utilitar precum Workbench. Pentru a putea face acest lucru trebuie sa avem acces la server (username/parola) si  acces la baza de date. Fom face aceasta conexiune printr-un tunel SSH folosind PuTTY.

Avem nevoie de urmatoarele informatii pentru a ne conecta:

  1. IP-ul Serverului
  2. Date de acces la server (root)
  3. Numele bazei de date, user-ul si parola.


Acum, dupa ce ne-am asigurat ca avem datele mentinoate mai sus putem incepe cu primul pas.

Pasul 1

Deschidem PuTTY si configuram parametri necesari conexiunii:

Pasul 2

Acum mergem la Connection > SSH > Tunnel

Pasul 3

Acum trebuie sa setam hostname-ul si portul tunelului.

Pasul 4

Apasa pe butonul Apply si porneste conexiunea.

Pasul 5

Acum ne autentificam din terminalul PuTTY cu user-ul ce are permisiuni de root.

Gata, ai stabilit o conexiune cu serverul, acum trebuie sa accesam serverul de baze de date cu workbench. Iata pasii pe care trebuie sa-i urmati pentru acest lucru.

Pasul 1

Deschide WorkBench

Pasul 2

Apasam pe iconita Add New Connection

Pasul 3

Acum trebuie sa scriem datele de conectare.

Pasul 4

Da-ti click pe butonul Test Connection, iar daca totul a fost setat corect va porni dahsboard-ul workbench.

Pasul 5

Daca totul a fost ok te poti conecta dand click pe conexiunea respectiva si scriind parola bazei de date.

Sunt un tanar programator din Bucuresti ce lucreaza in PHP/Mysql (MySqli/PDO), Laravel, CodeIgniter, MySQL, PostgreSQL, Wordpress, HTML5/CSS3, Sass, Photoshop si multe altele.
Google+ Community Facebook Group
Acest articol a fost mutat de pe vechea platforma.
Pentru orice eroare aparuta la mutare va rog sa ma contactati!

Comentariu postate de g la data de 13.05.2019
Fantastic website you have here but I was wanting to know if you knew of any user discussion forums that cover the same topics discussed here? I'd really like to be a part of online community where I can get suggestions from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Thanks!
Comentariu postate de download minecraft for free la data de 14.05.2019
What i don't understood is in fact how you are not actually a lot more neatly-preferred than you may be right now. You're very intelligent. You realize thus considerably relating to this subject, made me individually imagine it from numerous varied angles. Its like men and women don't seem to be interested until it's something to do with Girl gaga! Your personal stuffs outstanding. All the time take care of it up!
Comentariu postate de minecraft free download la data de 15.05.2019
Good web site you have here.. It's hard to find good quality writing like yours nowadays. I seriously appreciate people like you! Take care!!
Comentariu postate de minecraft pc download la data de 16.05.2019
I'm really loving the theme/design of your website. Do you ever run into any internet browser compatibility problems? A few of my blog visitors have complained about my site not working correctly in Explorer but looks great in Firefox. Do you have any recommendations to help fix this issue?
Comentariu postate de minecraft download mojang la data de 16.05.2019
Hi my family member! I wish to say that this article is amazing, nice written and include almost all vital infos. I'd like to look extra posts like this .