ssh 검색 결과
2 개의 검색 결과가 있습니다.
Data Science/Python

[Python] Transfer Pandas Dataframe to MYSQL database with SSH

in the terminal for local port forwarding: ssh -N -v username@hostname -L3306:127.0.0.1:3306 sqlalchemy for the connection : from sqlalchemy import create_engine engine = create_engine("mysql+pymysql://user:password@127.0.0.1:3306/dbname?charset=utf8" df.to_sql(con=engine, name='dest_table', if_exists='replace')

2023. 2. 22. 23:03
Shell & Command

[Shell] SSH

SSH Secure Shell (SSH) is a protocol that provides secure communication between two computers. It allows you to connect to a remote server securely and remotely execute commands on it. SSH is widely used by system administrators and developers to manage servers, transfer files, and execute remote commands. In this article, we'll cover some of the basic SSH shell commands you can use to interact ..

2023. 2. 22. 22:54
반응형
반응형