[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 
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
    connection.close()
 
 
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

 

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

 

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

 

 

본 웹사이트는 광고를 포함하고 있습니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.
대표 김성준 주소 : 경기 용인 분당수지 U타워 등록번호 : 142-07-27414
통신판매업 신고 : 제2012-용인수지-0185호 출판업 신고 : 수지구청 제 123호 개인정보보호최고책임자 : 김성준 sjkim70@stechstar.com
대표전화 : 010-4589-2193 [fax] 02-6280-1294 COPYRIGHT(C) stechstar.com ALL RIGHTS RESERVED