mysql的設置
創(chuàng)建數(shù)據(jù)庫：create database website character set utf8;
設置了字符串為utf8，以保證后面不出錯
import pymysql
pymysql.install_as_MySQLdb()
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'website',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '192.168.123.124',
'PORT': '3306',
}
}
遇到問題
[mysql"Access denied for user'root'@'IP地址'"問題]
解決方法是給予權(quán)限：
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
然后成功將本地數(shù)據(jù)上傳到數(shù)據(jù)庫
