Mac m1 / mysql 설치 및 실행

0. 설치

/usr/sbin/softwareupdate --install-rosetta --agree-to-license
arch -x86_64 /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
arch -x86_64 brew install mysql

1. 서버 실행

sudo chown -R _mysql:mysql /usr/local/var/mysql
sudo mysql.server start

2. 데이터 베이스 접속

mysql -u root -p

3. SQLAlchemy 설치

pip install sqlalchemy
pip install mysql-connector-python

4. config.py 설정

db = {
    "user": "root",
    "password": "0000",
    "host": "localhost",
    "port": 3306,
    "database": "miniter",
}
DB_URL = f"mysql+mysqlconnector://{db['user']}:{db['password']}@{db['host']}:{db['port']}/{db['database']}?charset=utf8"