您好,登錄后才能下訂單哦!
準(zhǔn)備開(kāi)始python的環(huán)境,用django框架其默認(rèn)的數(shù)據(jù)庫(kù)是sqlite3 ,要改用mysql來(lái)存儲(chǔ)數(shù)據(jù)
在執(zhí)行migrate的時(shí)候出現(xiàn)問(wèn)題(錯(cuò)誤見(jiàn)末尾):
Unhandled exception in thread started by <function check_errors.<locals>.wrapper
at 0x031BD6F0>
Traceback (most recent call last):
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 213
, in ensure_connection
self.connect()
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 189
, in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Python36\lib\site-packages\django\db\backends\mysql\base.py", line 27
4, in get_new_connection
conn = Database.connect(**conn_params)
File "C:\Python36\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "C:\Python36\lib\site-packages\MySQLdb\connections.py", line 204, in __in
it__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'ODBC'@'local
host' (using password: YES)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Python36\lib\site-packages\django\utils\autoreload.py", line 227, in
wrapper
fn(*args, **kwargs)
File "C:\Python36\lib\site-packages\django\core\management\commands\runserver.
py", line 125, in inner_run
self.check(display_num_errors=True)
File "C:\Python36\lib\site-packages\django\core\management\base.py", line 359,
in check
include_deployment_checks=include_deployment_checks,
File "C:\Python36\lib\site-packages\django\core\management\base.py", line 346,
in _run_checks
return checks.run_checks(**kwargs)
File "C:\Python36\lib\site-packages\django\core\checks\registry.py", line 81,
in run_checks
new_errors = check(app_configs=app_configs)
File "C:\Python36\lib\site-packages\django\core\checks\model_checks.py", line
30, in check_all_models
errors.extend(model.check(**kwargs))
File "C:\Python36\lib\site-packages\django\db\models\base.py", line 1282, in c
heck
errors.extend(cls._check_fields(**kwargs))
File "C:\Python36\lib\site-packages\django\db\models\base.py", line 1357, in _
check_fields
errors.extend(field.check(**kwargs))
File "C:\Python36\lib\site-packages\django\db\models\fields\__init__.py", line
909, in check
errors = super(AutoField, self).check(**kwargs)
File "C:\Python36\lib\site-packages\django\db\models\fields\__init__.py", line
219, in check
errors.extend(self._check_backend_specific_checks(**kwargs))
File "C:\Python36\lib\site-packages\django\db\models\fields\__init__.py", line
322, in _check_backend_specific_checks
return connections[db].validation.check_field(self, **kwargs)
File "C:\Python36\lib\site-packages\django\db\backends\mysql\validation.py", l
ine 49, in check_field
field_type = field.db_type(self.connection)
File "C:\Python36\lib\site-packages\django\db\models\fields\__init__.py", line
640, in db_type
return connection.data_types[self.get_internal_type()] % data
File "C:\Python36\lib\site-packages\django\utils\functional.py", line 35, in _
_get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Python36\lib\site-packages\django\db\backends\mysql\base.py", line 17
4, in data_types
if self.features.supports_microsecond_precision:
File "C:\Python36\lib\site-packages\django\utils\functional.py", line 35, in _
_get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Python36\lib\site-packages\django\db\backends\mysql\features.py", lin
e 53, in supports_microsecond_precision
return self.connection.mysql_version >= (5, 6, 4) and Database.version_info
>= (1, 2, 5)
File "C:\Python36\lib\site-packages\django\utils\functional.py", line 35, in _
_get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Python36\lib\site-packages\django\db\backends\mysql\base.py", line 38
5, in mysql_version
with self.temporary_connection() as cursor:
File "C:\Python36\lib\contextlib.py", line 82, in __enter__
return next(self.gen)
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 591
, in temporary_connection
cursor = self.cursor()
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 254
, in cursor
return self._cursor()
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 229
, in _cursor
self.ensure_connection()
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 213
, in ensure_connection
self.connect()
File "C:\Python36\lib\site-packages\django\db\utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\Python36\lib\site-packages\django\utils\six.py", line 685, in reraise
raise value.with_traceback(tb)
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 213
, in ensure_connection
self.connect()
File "C:\Python36\lib\site-packages\django\db\backends\base\base.py", line 189
, in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Python36\lib\site-packages\django\db\backends\mysql\base.py", line 27
4, in get_new_connection
conn = Database.connect(**conn_params)
File "C:\Python36\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "C:\Python36\lib\site-packages\MySQLdb\connections.py", line 204, in __in
it__
super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (1045, "Access denied for user 'ODBC'@'localho
st' (using password: YES)")
這里很奇怪為什么我配置的用戶(hù)是 admin_py 怎么會(huì)顯示 ‘ODBC’@‘localhost’?
有人說(shuō)是賬號(hào)密碼錯(cuò)誤,通過(guò)報(bào)錯(cuò)看來(lái)的和賬號(hào)密碼錯(cuò)誤相關(guān),但是手工去登陸mysql是OK的??!
折騰了一會(huì)兒,仔細(xì)看官方文檔配置:
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql', 'NAME': 'mydatabase', 'USER': 'mydatabaseuser', 'PASSWORD': 'mypassword', 'HOST': '127.0.0.1', 'PORT': '5432', }}
我自己的配置:
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'HOST': '127.0.0.1', 'PORT': 3306, 'NAME': 'platform_admin_py', 'USERNAME': 'admin_py', 'PASSWORD': 'admin', } }
發(fā)現(xiàn)了沒(méi)有?用戶(hù)名的的那個(gè)KEY不對(duì)! 我承認(rèn)我這是從網(wǎng)上看別人的配置寫(xiě)的,偷懶了,這就是代價(jià)
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。