- 전체
- Python 일반
- Python 수학
- Python 그래픽
- Python 자료구조
- Python 인공지능
- Python 인터넷
- Python SAGE
- wxPython
- TkInter
- iPython
- wxPython
- pyQT
- Jython
- django
- flask
- blender python scripting
- python for minecraft
- Python 데이터 분석
- Python RPA
- cython
- PyCharm
- pySide
Python 자료구조 [python][자료구조] python anaconda 에서 mysql 접속
2022.01.25 12:32
[python][자료구조] python anaconda 에서 mysql 접속
Connecting to MySQL
Anaconda Enterprise enables you to easily connect to a MySQL relational database management system (RDBMS), to access the data stored in it.
Before you can do so, however, you’ll need to install the mysql-connector-python
conda package, which contains the Python driver for communicating with MySQL servers:
conda install -c anaconda mysql-connector-python
NOTE: Any packages you install from the command line are available during the current session only. If you want them to persist, add them to the project’s anaconda-project.yml
file. For more information, see Developing a project.
You can then use code such as this to connect to MySQL from within a notebook session:
import mysql.connector as mysql
import json
# Get credentials from Kubernetes. The credentials were setup as a dictionary.
credentials = None
with open('/var/run/secrets/user_credentials/mysql_credentials') as f:
credentials = json.load(f)
# Ensure your credentials were setup
if credentials:
# Connect to the DB
connection = mysql.connect(
user=credentials.get('username'),
password=credentials.get('password'),
database='employees',
host='support-mysql.dev.anaconda.com'
)
cursor = connection.cursor()
# Execute the query
cursor.execute("SELECT first_name, last_name FROM employees LIMIT 20")
# Loop through the results
for first_name, last_name in cursor:
print(f'First name: {first_name}, Last name: {last_name}')
# Close the connection
See Storing secrets for information about adding credentials to the platform, to make them available in your projects. Any secrets you add will be available across all sessions and deployments associated with your user account.
[출처] https://enterprise-docs.anaconda.com/en/latest/data-science-workflows/data/mysql.html
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
10 | [python 수학] [Numpy] 넘파이 기본 문법 정리 | 졸리운_곰 | 2023.11.28 | 24 |
9 | [python 수학] Numpy 많이쓰는 함수 정리 | 졸리운_곰 | 2023.11.28 | 23 |
8 | [Python 수학] Python/데이터 사이언스 [파이썬] Numpy 정리 | 졸리운_곰 | 2023.11.28 | 13 |
7 | [python][anaconda] 파이썬3(python3) 설치하고 환경(env) 관리하기 - 아나콘다3(anaconda3)를 활용한 설치 | 졸리운_곰 | 2022.01.20 | 16 |
6 | [python][anaconda] 파이선 아나콘다 최신 버전 업데이트하기 | 졸리운_곰 | 2022.01.20 | 38 |
5 | [python] 시험삼아 만들어본 로또 번호 생성기 | 졸리운_곰 | 2017.02.28 | 1812 |
4 | Introduction to Python for Econometrics_Statistics and Data Analysis.pdf | 졸리운_곰 | 2016.06.07 | 2101 |
3 | Numerical.Methods.in.Engineering.with.Python.2nd.Edition.Jaan.Kiusalaas.2010.pdf | 졸리운_곰 | 2016.06.07 | 1913 |
2 | NumMethodPython.pdf | 졸리운_곰 | 2016.06.07 | 1949 |
1 | Python-for-Computational-Science-and-Engineering.pdf | 졸리운_곰 | 2016.06.07 | 1936 |