bind mysql django_Django连接MySQL数据库

最新推荐文章于 2022-05-09 23:36:47 发布
最新推荐文章于 2022-05-09 23:36:47 发布
阅读量106 收藏
点赞数
文章标签： bind mysql django
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_30478151/article/details/113376205
版权

一．先安装pymysql模块

pip3 install pymysql

二.创建一个项目(helloworld)然后进入到项目目录中执行：

[root@master1 helloworld]# python manage.py startapp testapp

进入到testapp目录

[root@master1 helloworld]# cd testapp/

[root@master1 testapp]# vim __init__.py

e8058ca25b17457f7ef2bcd8ff96d5bb.png

导入pymysql模块(“我这里是使用绝对路径导入的”)

import sys

from sys import path

path.append(r'/usr/local/lib64/python3.6/site-packages/pymysql')

import pymysql

from pymysql import *

pymysql.install_as_MySQLdb()

在进入到helloworld项目中:

[root@master1 helloworld]# cd helloworld/

[root@master1 helloworld]# vim __init__.py

ff68439c483039bfb4cae7cd8429a4fb.png

import sys

from sys import path

path.append(r'/usr/local/lib64/python3.6/site-packages/pymysql')

import pymysql

from pymysql import *

pymysql.install_as_MySQLdb()

修改”settings.py”中的DATABASE数据库连接信息#：注意这里也要导入pymysql模块

df61bb1ce7ca735a20af2068ce4af80d.png

187d9fddd7b1a004d4a262258a5d8d74.png

加载测试数据库：

36fc9afe9209fd5112538459e356b2f3.png

[root@master1 helloworld]# python manage.py inspectdb

将产生的class全部赋值到models.py文件中:

daccda95403c4dbe053e1a18dfe7f16f.png

class ColumnsPriv(models.Model):

host = models.CharField(db_column='Host', primary_key=True, max_length=60)  # Field name made lowercase.

db = models.CharField(db_column='Db', max_length=64)  # Field name made lowercase.

user = models.CharField(db_column='User', max_length=32)  # Field name made lowercase.

table_name = models.CharField(db_column='Table_name', max_length=64)  # Field name made lowercase.

column_name = models.CharField(db_column='Column_name', max_length=64)  # Field name made lowercase.

timestamp = models.DateTimeField(db_column='Timestamp')  # Field name made lowercase.

column_priv = models.CharField(db_column='Column_priv', max_length=31)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'columns_priv'

unique_together = (('host', 'db', 'user', 'table_name', 'column_name'),)

class Db(models.Model):

host = models.CharField(db_column='Host', primary_key=True, max_length=60)  # Field name made lowercase.

db = models.CharField(db_column='Db', max_length=64)  # Field name made lowercase.

user = models.CharField(db_column='User', max_length=32)  # Field name made lowercase.

select_priv = models.CharField(db_column='Select_priv', max_length=1)  # Field name made lowercase.

insert_priv = models.CharField(db_column='Insert_priv', max_length=1)  # Field name made lowercase.

update_priv = models.CharField(db_column='Update_priv', max_length=1)  # Field name made lowercase.

delete_priv = models.CharField(db_column='Delete_priv', max_length=1)  # Field name made lowercase.

create_priv = models.CharField(db_column='Create_priv', max_length=1)  # Field name made lowercase.

drop_priv = models.CharField(db_column='Drop_priv', max_length=1)  # Field name made lowercase.

grant_priv = models.CharField(db_column='Grant_priv', max_length=1)  # Field name made lowercase.

references_priv = models.CharField(db_column='References_priv', max_length=1)  # Field name made lowercase.

index_priv = models.CharField(db_column='Index_priv', max_length=1)  # Field name made lowercase.

alter_priv = models.CharField(db_column='Alter_priv', max_length=1)  # Field name made lowercase.

create_tmp_table_priv = models.CharField(db_column='Create_tmp_table_priv', max_length=1)  # Field name made lowercase.

lock_tables_priv = models.CharField(db_column='Lock_tables_priv', max_length=1)  # Field name made lowercase.

create_view_priv = models.CharField(db_column='Create_view_priv', max_length=1)  # Field name made lowercase.

show_view_priv = models.CharField(db_column='Show_view_priv', max_length=1)  # Field name made lowercase.

create_routine_priv = models.CharField(db_column='Create_routine_priv', max_length=1)  # Field name made lowercase.

alter_routine_priv = models.CharField(db_column='Alter_routine_priv', max_length=1)  # Field name made lowercase.

execute_priv = models.CharField(db_column='Execute_priv', max_length=1)  # Field name made lowercase.

event_priv = models.CharField(db_column='Event_priv', max_length=1)  # Field name made lowercase.

trigger_priv = models.CharField(db_column='Trigger_priv', max_length=1)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'db'

unique_together = (('host', 'db', 'user'),)

class EngineCost(models.Model):

engine_name = models.CharField(max_length=64)

device_type = models.IntegerField()

cost_name = models.CharField(primary_key=True, max_length=64)

cost_value = models.FloatField(blank=True, null=True)

last_update = models.DateTimeField()

comment = models.CharField(max_length=1024, blank=True, null=True)

class Meta:

managed = False

db_table = 'engine_cost'

unique_together = (('cost_name', 'engine_name', 'device_type'),)

class Event(models.Model):

db = models.CharField(primary_key=True, max_length=64)

name = models.CharField(max_length=64)

body = models.TextField()

definer = models.CharField(max_length=77)

execute_at = models.DateTimeField(blank=True, null=True)

interval_value = models.IntegerField(blank=True, null=True)

interval_field = models.CharField(max_length=18, blank=True, null=True)

created = models.DateTimeField()

modified = models.DateTimeField()

last_executed = models.DateTimeField(blank=True, null=True)

starts = models.DateTimeField(blank=True, null=True)

ends = models.DateTimeField(blank=True, null=True)

status = models.CharField(max_length=18)

on_completion = models.CharField(max_length=8)

sql_mode = models.CharField(max_length=478)

comment = models.CharField(max_length=64)

originator = models.PositiveIntegerField()

time_zone = models.CharField(max_length=64)

character_set_client = models.CharField(max_length=32, blank=True, null=True)

collation_connection = models.CharField(max_length=32, blank=True, null=True)

db_collation = models.CharField(max_length=32, blank=True, null=True)

body_utf8 = models.TextField(blank=True, null=True)

class Meta:

managed = False

db_table = 'event'

unique_together = (('db', 'name'),)

class Func(models.Model):

name = models.CharField(primary_key=True, max_length=64)

ret = models.IntegerField()

dl = models.CharField(max_length=128)

type = models.CharField(max_length=9)

class Meta:

managed = False

db_table = 'func'

class GeneralLog(models.Model):

event_time = models.DateTimeField()

user_host = models.TextField()

thread_id = models.BigIntegerField()

server_id = models.PositiveIntegerField()

command_type = models.CharField(max_length=64)

argument = models.TextField()

class Meta:

managed = False

db_table = 'general_log'

class GtidExecuted(models.Model):

source_uuid = models.CharField(primary_key=True, max_length=36)

interval_start = models.BigIntegerField()

interval_end = models.BigIntegerField()

class Meta:

managed = False

db_table = 'gtid_executed'

unique_together = (('source_uuid', 'interval_start'),)

class HelpCategory(models.Model):

help_category_id = models.PositiveSmallIntegerField(primary_key=True)

name = models.CharField(unique=True, max_length=64)

parent_category_id = models.PositiveSmallIntegerField(blank=True, null=True)

url = models.TextField()

class Meta:

managed = False

db_table = 'help_category'

class HelpKeyword(models.Model):

help_keyword_id = models.PositiveIntegerField(primary_key=True)

name = models.CharField(unique=True, max_length=64)

class Meta:

managed = False

db_table = 'help_keyword'

class HelpRelation(models.Model):

help_topic_id = models.PositiveIntegerField()

help_keyword_id = models.PositiveIntegerField(primary_key=True)

class Meta:

managed = False

db_table = 'help_relation'

unique_together = (('help_keyword_id', 'help_topic_id'),)

class HelpTopic(models.Model):

help_topic_id = models.PositiveIntegerField(primary_key=True)

name = models.CharField(unique=True, max_length=64)

help_category_id = models.PositiveSmallIntegerField()

description = models.TextField()

example = models.TextField()

url = models.TextField()

class Meta:

managed = False

db_table = 'help_topic'

class InnodbIndexStats(models.Model):

database_name = models.CharField(primary_key=True, max_length=64)

table_name = models.CharField(max_length=64)

index_name = models.CharField(max_length=64)

last_update = models.DateTimeField()

stat_name = models.CharField(max_length=64)

stat_value = models.BigIntegerField()

sample_size = models.BigIntegerField(blank=True, null=True)

stat_description = models.CharField(max_length=1024)

class Meta:

managed = False

db_table = 'innodb_index_stats'

unique_together = (('database_name', 'table_name', 'index_name', 'stat_name'),)

class InnodbTableStats(models.Model):

database_name = models.CharField(primary_key=True, max_length=64)

table_name = models.CharField(max_length=64)

last_update = models.DateTimeField()

n_rows = models.BigIntegerField()

clustered_index_size = models.BigIntegerField()

sum_of_other_index_sizes = models.BigIntegerField()

class Meta:

managed = False

db_table = 'innodb_table_stats'

unique_together = (('database_name', 'table_name'),)

class NdbBinlogIndex(models.Model):

position = models.BigIntegerField(db_column='Position')  # Field name made lowercase.

file = models.CharField(db_column='File', max_length=255)  # Field name made lowercase.

epoch = models.BigIntegerField(primary_key=True)

inserts = models.PositiveIntegerField()

updates = models.PositiveIntegerField()

deletes = models.PositiveIntegerField()

schemaops = models.PositiveIntegerField()

orig_server_id = models.PositiveIntegerField()

orig_epoch = models.BigIntegerField()

gci = models.PositiveIntegerField()

next_position = models.BigIntegerField()

next_file = models.CharField(max_length=255)

class Meta:

managed = False

db_table = 'ndb_binlog_index'

unique_together = (('epoch', 'orig_server_id', 'orig_epoch'),)

class Plugin(models.Model):

name = models.CharField(primary_key=True, max_length=64)

dl = models.CharField(max_length=128)

class Meta:

managed = False

db_table = 'plugin'

class Proc(models.Model):

db = models.CharField(primary_key=True, max_length=64)

name = models.CharField(max_length=64)

type = models.CharField(max_length=9)

specific_name = models.CharField(max_length=64)

language = models.CharField(max_length=3)

sql_data_access = models.CharField(max_length=17)

is_deterministic = models.CharField(max_length=3)

security_type = models.CharField(max_length=7)

param_list = models.TextField()

returns = models.TextField()

body = models.TextField()

definer = models.CharField(max_length=77)

created = models.DateTimeField()

modified = models.DateTimeField()

sql_mode = models.CharField(max_length=478)

comment = models.TextField()

character_set_client = models.CharField(max_length=32, blank=True, null=True)

collation_connection = models.CharField(max_length=32, blank=True, null=True)

db_collation = models.CharField(max_length=32, blank=True, null=True)

body_utf8 = models.TextField(blank=True, null=True)

class Meta:

managed = False

db_table = 'proc'

unique_together = (('db', 'name', 'type'),)

class ProcsPriv(models.Model):

host = models.CharField(db_column='Host', primary_key=True, max_length=60)  # Field name made lowercase.

db = models.CharField(db_column='Db', max_length=64)  # Field name made lowercase.

user = models.CharField(db_column='User', max_length=32)  # Field name made lowercase.

routine_name = models.CharField(db_column='Routine_name', max_length=64)  # Field name made lowercase.

routine_type = models.CharField(db_column='Routine_type', max_length=9)  # Field name made lowercase.

grantor = models.CharField(db_column='Grantor', max_length=77)  # Field name made lowercase.

proc_priv = models.CharField(db_column='Proc_priv', max_length=27)  # Field name made lowercase.

timestamp = models.DateTimeField(db_column='Timestamp')  # Field name made lowercase.

class Meta:

managed = False

db_table = 'procs_priv'

unique_together = (('host', 'db', 'user', 'routine_name', 'routine_type'),)

class ProxiesPriv(models.Model):

host = models.CharField(db_column='Host', primary_key=True, max_length=60)  # Field name made lowercase.

user = models.CharField(db_column='User', max_length=32)  # Field name made lowercase.

proxied_host = models.CharField(db_column='Proxied_host', max_length=60)  # Field name made lowercase.

proxied_user = models.CharField(db_column='Proxied_user', max_length=32)  # Field name made lowercase.

with_grant = models.IntegerField(db_column='With_grant')  # Field name made lowercase.

grantor = models.CharField(db_column='Grantor', max_length=77)  # Field name made lowercase.

timestamp = models.DateTimeField(db_column='Timestamp')  # Field name made lowercase.

class Meta:

managed = False

db_table = 'proxies_priv'

unique_together = (('host', 'user', 'proxied_host', 'proxied_user'),)

class ServerCost(models.Model):

cost_name = models.CharField(primary_key=True, max_length=64)

cost_value = models.FloatField(blank=True, null=True)

last_update = models.DateTimeField()

comment = models.CharField(max_length=1024, blank=True, null=True)

class Meta:

managed = False

db_table = 'server_cost'

class Servers(models.Model):

server_name = models.CharField(db_column='Server_name', primary_key=True, max_length=64)  # Field name made lowercase.

host = models.CharField(db_column='Host', max_length=64)  # Field name made lowercase.

db = models.CharField(db_column='Db', max_length=64)  # Field name made lowercase.

username = models.CharField(db_column='Username', max_length=64)  # Field name made lowercase.

password = models.CharField(db_column='Password', max_length=64)  # Field name made lowercase.

port = models.IntegerField(db_column='Port')  # Field name made lowercase.

socket = models.CharField(db_column='Socket', max_length=64)  # Field name made lowercase.

wrapper = models.CharField(db_column='Wrapper', max_length=64)  # Field name made lowercase.

owner = models.CharField(db_column='Owner', max_length=64)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'servers'

class SlaveMasterInfo(models.Model):

number_of_lines = models.PositiveIntegerField(db_column='Number_of_lines')  # Field name made lowercase.

master_log_name = models.TextField(db_column='Master_log_name')  # Field name made lowercase.

master_log_pos = models.BigIntegerField(db_column='Master_log_pos')  # Field name made lowercase.

host = models.CharField(db_column='Host', max_length=64, blank=True, null=True)  # Field name made lowercase.

user_name = models.TextField(db_column='User_name', blank=True, null=True)  # Field name made lowercase.

user_password = models.TextField(db_column='User_password', blank=True, null=True)  # Field name made lowercase.

port = models.PositiveIntegerField(db_column='Port')  # Field name made lowercase.

connect_retry = models.PositiveIntegerField(db_column='Connect_retry')  # Field name made lowercase.

enabled_ssl = models.IntegerField(db_column='Enabled_ssl')  # Field name made lowercase.

ssl_ca = models.TextField(db_column='Ssl_ca', blank=True, null=True)  # Field name made lowercase.

ssl_capath = models.TextField(db_column='Ssl_capath', blank=True, null=True)  # Field name made lowercase.

ssl_cert = models.TextField(db_column='Ssl_cert', blank=True, null=True)  # Field name made lowercase.

ssl_cipher = models.TextField(db_column='Ssl_cipher', blank=True, null=True)  # Field name made lowercase.

ssl_key = models.TextField(db_column='Ssl_key', blank=True, null=True)  # Field name made lowercase.

ssl_verify_server_cert = models.IntegerField(db_column='Ssl_verify_server_cert')  # Field name made lowercase.

heartbeat = models.FloatField(db_column='Heartbeat')  # Field name made lowercase.

bind = models.TextField(db_column='Bind', blank=True, null=True)  # Field name made lowercase.

ignored_server_ids = models.TextField(db_column='Ignored_server_ids', blank=True, null=True)  # Field name made lowercase.

uuid = models.TextField(db_column='Uuid', blank=True, null=True)  # Field name made lowercase.

retry_count = models.BigIntegerField(db_column='Retry_count')  # Field name made lowercase.

ssl_crl = models.TextField(db_column='Ssl_crl', blank=True, null=True)  # Field name made lowercase.

ssl_crlpath = models.TextField(db_column='Ssl_crlpath', blank=True, null=True)  # Field name made lowercase.

enabled_auto_position = models.IntegerField(db_column='Enabled_auto_position')  # Field name made lowercase.

channel_name = models.CharField(db_column='Channel_name', primary_key=True, max_length=64)  # Field name made lowercase.

tls_version = models.TextField(db_column='Tls_version', blank=True, null=True)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'slave_master_info'

class SlaveRelayLogInfo(models.Model):

number_of_lines = models.PositiveIntegerField(db_column='Number_of_lines')  # Field name made lowercase.

relay_log_name = models.TextField(db_column='Relay_log_name')  # Field name made lowercase.

relay_log_pos = models.BigIntegerField(db_column='Relay_log_pos')  # Field name made lowercase.

master_log_name = models.TextField(db_column='Master_log_name')  # Field name made lowercase.

master_log_pos = models.BigIntegerField(db_column='Master_log_pos')  # Field name made lowercase.

sql_delay = models.IntegerField(db_column='Sql_delay')  # Field name made lowercase.

number_of_workers = models.PositiveIntegerField(db_column='Number_of_workers')  # Field name made lowercase.

id = models.PositiveIntegerField(db_column='Id')  # Field name made lowercase.

channel_name = models.CharField(db_column='Channel_name', primary_key=True, max_length=64)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'slave_relay_log_info'

class SlaveWorkerInfo(models.Model):

id = models.PositiveIntegerField(db_column='Id')  # Field name made lowercase.

relay_log_name = models.TextField(db_column='Relay_log_name')  # Field name made lowercase.

relay_log_pos = models.BigIntegerField(db_column='Relay_log_pos')  # Field name made lowercase.

master_log_name = models.TextField(db_column='Master_log_name')  # Field name made lowercase.

master_log_pos = models.BigIntegerField(db_column='Master_log_pos')  # Field name made lowercase.

checkpoint_relay_log_name = models.TextField(db_column='Checkpoint_relay_log_name')  # Field name made lowercase.

checkpoint_relay_log_pos = models.BigIntegerField(db_column='Checkpoint_relay_log_pos')  # Field name made lowercase.

checkpoint_master_log_name = models.TextField(db_column='Checkpoint_master_log_name')  # Field name made lowercase.

checkpoint_master_log_pos = models.BigIntegerField(db_column='Checkpoint_master_log_pos')  # Field name made lowercase.

checkpoint_seqno = models.PositiveIntegerField(db_column='Checkpoint_seqno')  # Field name made lowercase.

checkpoint_group_size = models.PositiveIntegerField(db_column='Checkpoint_group_size')  # Field name made lowercase.

checkpoint_group_bitmap = models.TextField(db_column='Checkpoint_group_bitmap')  # Field name made lowercase.

channel_name = models.CharField(db_column='Channel_name', primary_key=True, max_length=64)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'slave_worker_info'

unique_together = (('channel_name', 'id'),)

class SlowLog(models.Model):

start_time = models.DateTimeField()

user_host = models.TextField()

query_time = models.TimeField()

lock_time = models.TimeField()

rows_sent = models.IntegerField()

rows_examined = models.IntegerField()

db = models.CharField(max_length=512)

last_insert_id = models.IntegerField()

insert_id = models.IntegerField()

server_id = models.PositiveIntegerField()

sql_text = models.TextField()

thread_id = models.BigIntegerField()

class Meta:

managed = False

db_table = 'slow_log'

class TablesPriv(models.Model):

host = models.CharField(db_column='Host', primary_key=True, max_length=60)  # Field name made lowercase.

db = models.CharField(db_column='Db', max_length=64)  # Field name made lowercase.

user = models.CharField(db_column='User', max_length=32)  # Field name made lowercase.

table_name = models.CharField(db_column='Table_name', max_length=64)  # Field name made lowercase.

grantor = models.CharField(db_column='Grantor', max_length=77)  # Field name made lowercase.

timestamp = models.DateTimeField(db_column='Timestamp')  # Field name made lowercase.

table_priv = models.CharField(db_column='Table_priv', max_length=98)  # Field name made lowercase.

column_priv = models.CharField(db_column='Column_priv', max_length=31)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'tables_priv'

unique_together = (('host', 'db', 'user', 'table_name'),)

class TimeZone(models.Model):

time_zone_id = models.AutoField(db_column='Time_zone_id', primary_key=True)  # Field name made lowercase.

use_leap_seconds = models.CharField(db_column='Use_leap_seconds', max_length=1)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'time_zone'

class TimeZoneLeapSecond(models.Model):

transition_time = models.BigIntegerField(db_column='Transition_time', primary_key=True)  # Field name made lowercase.

correction = models.IntegerField(db_column='Correction')  # Field name made lowercase.

class Meta:

managed = False

db_table = 'time_zone_leap_second'

class TimeZoneName(models.Model):

name = models.CharField(db_column='Name', primary_key=True, max_length=64)  # Field name made lowercase.

time_zone_id = models.PositiveIntegerField(db_column='Time_zone_id')  # Field name made lowercase.

class Meta:

managed = False

db_table = 'time_zone_name'

class TimeZoneTransition(models.Model):

time_zone_id = models.PositiveIntegerField(db_column='Time_zone_id', primary_key=True)  # Field name made lowercase.

transition_time = models.BigIntegerField(db_column='Transition_time')  # Field name made lowercase.

transition_type_id = models.PositiveIntegerField(db_column='Transition_type_id')  # Field name made lowercase.

class Meta:

managed = False

db_table = 'time_zone_transition'

unique_together = (('time_zone_id', 'transition_time'),)

class TimeZoneTransitionType(models.Model):

time_zone_id = models.PositiveIntegerField(db_column='Time_zone_id', primary_key=True)  # Field name made lowercase.

transition_type_id = models.PositiveIntegerField(db_column='Transition_type_id')  # Field name made lowercase.

offset = models.IntegerField(db_column='Offset')  # Field name made lowercase.

is_dst = models.PositiveIntegerField(db_column='Is_DST')  # Field name made lowercase.

abbreviation = models.CharField(db_column='Abbreviation', max_length=8)  # Field name made lowercase.

class Meta:

managed = False

db_table = 'time_zone_transition_type'

unique_together = (('time_zone_id', 'transition_type_id'),)

class User(models.Model):

host = models.CharField(db_column='Host', primary_key=True, max_length=60)  # Field name made lowercase.

user = models.CharField(db_column='User', max_length=32)  # Field name made lowercase.

select_priv = models.CharField(db_column='Select_priv', max_length=1)  # Field name made lowercase.

insert_priv = models.CharField(db_column='Insert_priv', max_length=1)  # Field name made lowercase.

update_priv = models.CharField(db_column='Update_priv', max_length=1)  # Field name made lowercase.

delete_priv = models.CharField(db_column='Delete_priv', max_length=1)  # Field name made lowercase.

create_priv = models.CharField(db_column='Create_priv', max_length=1)  # Field name made lowercase.

drop_priv = models.CharField(db_column='Drop_priv', max_length=1)  # Field name made lowercase.

reload_priv = models.CharField(db_column='Reload_priv', max_length=1)  # Field name made lowercase.

shutdown_priv = models.CharField(db_column='Shutdown_priv', max_length=1)  # Field name made lowercase.

process_priv = models.CharField(db_column='Process_priv', max_length=1)  # Field name made lowercase.

file_priv = models.CharField(db_column='File_priv', max_length=1)  # Field name made lowercase.

grant_priv = models.CharField(db_column='Grant_priv', max_length=1)  # Field name made lowercase.

references_priv = models.CharField(db_column='References_priv', max_length=1)  # Field name made lowercase.

index_priv = models.CharField(db_column='Index_priv', max_length=1)  # Field name made lowercase.

alter_priv = models.CharField(db_column='Alter_priv', max_length=1)  # Field name made lowercase.

show_db_priv = models.CharField(db_column='Show_db_priv', max_length=1)  # Field name made lowercase.

super_priv = models.CharField(db_column='Super_priv', max_length=1)  # Field name made lowercase.

create_tmp_table_priv = models.CharField(db_column='Create_tmp_table_priv', max_length=1)  # Field name made lowercase.

lock_tables_priv = models.CharField(db_column='Lock_tables_priv', max_length=1)  # Field name made lowercase.

execute_priv = models.CharField(db_column='Execute_priv', max_length=1)  # Field name made lowercase.

repl_slave_priv = models.CharField(db_column='Repl_slave_priv', max_length=1)  # Field name made lowercase.

repl_client_priv = models.CharField(db_column='Repl_client_priv', max_length=1)  # Field name made lowercase.

create_view_priv = models.CharField(db_column='Create_view_priv', max_length=1)  # Field name made lowercase.

show_view_priv = models.CharField(db_column='Show_view_priv', max_length=1)  # Field name made lowercase.

create_routine_priv = models.CharField(db_column='Create_routine_priv', max_length=1)  # Field name made lowercase.

alter_routine_priv = models.CharField(db_column='Alter_routine_priv', max_length=1)  # Field name made lowercase.

create_user_priv = models.CharField(db_column='Create_user_priv', max_length=1)  # Field name made lowercase.

event_priv = models.CharField(db_column='Event_priv', max_length=1)  # Field name made lowercase.

trigger_priv = models.CharField(db_column='Trigger_priv', max_length=1)  # Field name made lowercase.

create_tablespace_priv = models.CharField(db_column='Create_tablespace_priv', max_length=1)  # Field name made lowercase.

ssl_type = models.CharField(max_length=9)

ssl_cipher = models.TextField()

x509_issuer = models.TextField()

x509_subject = models.TextField()

max_questions = models.PositiveIntegerField()

max_updates = models.PositiveIntegerField()

max_connections = models.PositiveIntegerField()

max_user_connections = models.PositiveIntegerField()

plugin = models.CharField(max_length=64)

authentication_string = models.TextField(blank=True, null=True)

password_expired = models.CharField(max_length=1)

password_last_changed = models.DateTimeField(blank=True, null=True)

password_lifetime = models.PositiveSmallIntegerField(blank=True, null=True)

account_locked = models.CharField(max_length=1)

class Meta:

managed = False

db_table = 'user'

unique_together = (('host', 'user'),)

开始执行测试连接MySQL：

[root@master1 helloworld]# cd helloworld/

[root@master1 helloworld]# python manage.py migrate

d480e797781ac4e88a2acd0372969750.png

查看MySQL数据库的表：

4c7b0bda98cf7c29579a50a692d7d6ba.png

遇到的坑：

连接不上mysql数据库：

可能是防火墙问题:systemctl stop firewalld

MySQL数据库没有开启远程连接：

mysql> update user set host='%' where user = 'root';

mysql> flush privileges;

a5495127c1017df0ca5f35e65fd3c786.png

oreman
关注
完整版 Python高级开发课程 高级教程 06 Python操作MySQL数据库.pptx
09-25
在本课程"Python高级开发课程 高级教程 06 Python操作...总的来说，这个Python高级开发课程涵盖了从基础的数据库连接到复杂的ORM应用，再到并发处理和NoSQL数据库的操作，旨在提升开发者在实际项目中的数据处理能力。
bind mysql django_Django+bind dlz DNS管理平台
weixin_30486717的博客
01-20 184
经过两周开发，DNS管理平台终于开发完成。今天正好有时间，给大家分享一下。1.整体架构 > DNS 服务器分成两组，每组在不同的机房。保障一组机器出现问题，减少对用户的影响。> 每组DNS服务器使用lvs，实现负载均衡。> 针对不同运营商的用户，可以将dns 服务器分成两个view(我分成了电信和其它，你可以根据自己的业务进行定义)。>使用dns的dlz功能，将z...
查看当前db的排序规则(collation)
serina_dsc的专栏
04-21 2575
查看排序规则sql code:SELECT SERVERPROPERTY (Collation) 也可以手动查看: 数据库属性对话框中查看 查看所有可用的排序规则sql code:SELECT nameFROM ::fn_helpcollations()  Result:name                                        
Django+bind dlz DNS管理平台
weixin_33896069的博客
07-15 320
经过两周开发，DNS管理平台终于开发完成。今天正好有时间，给大家分享一下。1.整体架构 > DNS 服务器分成两组，每组在不同的机房。保障一组机器出现问题，减少对用户的影响。 > 每组DNS服务器使用lvs，实现负载均衡。 > 针对不同运营商的用户，可以将dns 服务器分成两个view(我分成了电信和其它，你...
Django从零开始----03Django字段类型
Ryuuku的博客
09-16 384
AutoField 一个 IntegerField，根据可用的 ID 自动递增。你通常不需要直接使用它；如果你没有指定，主键字段会自动添加到你的模型中。 BigAutoField 一个 64 位整数，与 AutoField 很相似，但保证适合 1 到 9223372036854775807 的数字。 BigIntegerField 一个 64 位的整数，和 IntegerField 很像，只是它保证适合从 -9223372036854775808 到 9223372036854775..
Django models.CharField()用法
qinzuoyu996的博客
12-13 5321
1.editable： $可编辑，如果设置为False，这个字段将不会出现在admin或者其他ModelForm，他们会跳过模型验证，默认为True 2.upload=''： $ 自定义图片和文件上传路径自定义图片和文件上传路径 3.default: $设置默认值 4.verbose_name： $ 就是在后台显示对对应的名称 5.blank=Ture与null=Ture的区别： $ null 是针对数据库..
pycharm远程连接vagrant虚拟机中mariadb数据库
09-08
总结来说，成功地使用PyCharm远程连接到Vagrant虚拟机中的MariaDB数据库，需要配置数据库的访问权限，正确设置PyCharm的数据库连接参数，以及解决可能遇到的时区问题。通过这种方式，开发人员可以在本地环境中高效地...
解析Mac OS下部署Pyhton的Django框架项目的过程
09-21
- 配置数据库连接： ```python DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'cmdb', 'USER': 'cmdb', 'PASSWORD': 'cmdb', 'HOST': 'localhost', 'PORT': '3306', } } ...
PythonWeb项目Django部署在Ubuntu18.04腾讯云主机上
09-19
- 运行`sudo mysql_secure_installation`来配置MySQL的安全性，包括设置root用户的密码、删除匿名用户等。 - 修改MySQL配置文件`/etc/mysql/mysql.conf.d/mysqld.cnf`，注释掉`bind-address`行以便允许远程连接。 ...
Django自学笔记 4-2 模型（models）中的Field（字段）
大爽老师的博客
03-25 760
————总目录——前言——框架版本———— ======================= 大爽歌作，made by big shuang ======================= 参考：https://docs.djangoproject.com/en/2.2/ref/models/fields/ 二、各种Field（字段）说明 一般来说，Field不需要另行导入，因为导入mode...
django 进行ldap登录验证
侧耳倾听の九月
07-06 6256
在django中进行ldap登录验证并不复杂，只需要在setting中进行一些配置即可。1.安装ldap库。pip install ldappip install django-auth-ldap2.在setting.py中导入import ldapfrom django_auth_ladp.config import LDAPSearch,GroupOfNamesType添加：AUTHENTIC...
bind mysql django_mysql配置－django
weixin_39597987的博客
02-23 99
mysql配置－django@(python)数据库配置像前面章节提到的 模版路径一样，数据库配置也是在Django的配置文件里，缺省 是 settings.py 。 打开这个文件并查找数据库配置：DATABASES = {'default': {'ENGINE': 'django.db.backends.sqlite3','NAME': os.path.join(BASE_DIR, 'db.sq...
【MySQL入门】（二）外部远程连接MySQL数据库
DooDoo~的博客
05-09 2883
【MySQL入门】（二）外部远程连接MySQL数据库 外部访问方式： 1. Terminal终端：`mysql -h x.x.x.x -P 3306 -u root -p密码` 2. 通过Navicat、phpMyAdmin等数据库管理软件连接MySQL数据库进行管理。 3. Python、Java等编程语言的工具包连接MySQL数据库。 外部无法访问原因排查： 1. MySQL配置文件bind-address 2. 账户是否允许外部访问 3. 数据库端口是否开放
bind mysql web_基于的django的bind dns管理平台
weixin_39583521的博客
01-26 488
BIND(Berkeley internet Name Daemon)也叫做NAMED，是现今互联网上使用最为广泛的DNS 服务器程序,本项目旨在更简单的维护我们内部的dns系统。环境：数据库: mysql5.6应用: bind-9.11.2环境: python3.８ , django30x01 安装数据库bash sql 建库语句use mysqlcreate database bind9; -...
十一周作业.zip
10-06
项目学习分享。【项目资源】：包含前端、后端、移动开发、操作系统、人工智能、物联网、信息化管理、数据库、硬件开发、大数据、课程资源、音视频、网站开发等各种技术项目的源码。包括STM32、ESP8266、PHP、QT、Linux、iOS、C++、Java、python、web、C#、EDA、proteus、RTOS等项目的源码。 【技术】 Java、Python、Node.js、Spring Boot、Django、Express、MySQL、PostgreSQL、MongoDB、React、Angular、Vue、Bootstrap、Material-UI、Redis、Docker、Kubernetes
基于Springboot和Vue的获奖的知名作家信息管理系统源码 获奖的知名作家信息管理系统代码
10-06
获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统-获奖的知名作家信息管理系统 1、资源说明：获奖的知名作家信息管理系统源码，本资源内项目代码都经过测试运行成功，功能ok的情况下才上传的。 2、适用人群：计算机相关专业(如计算计、信息安全、大数据、人工智能、通信、物联网、自动化、电子信息等)在校学生、专业老师或者企业员工等学习者，作为参考资料，进行参考学习使用。 3、资源用途：本资源具有较高的学习借鉴价值，可以作为“参考资料”，注意不是“定制需求”，代码只能作为学习参考，不能完全复制照搬。需要有一定的基础，能够看懂代码，能够自行调试代码，能够自行添加功能修改代码。 4. 最新计算机软件毕业设计选题大全(文章底部有博主联系方式): https://blog.csdn.net/2301_79206800/article/detail
基于matlab的作业调度问题 采用遗传算法，解决作业调度问题 一共三个作业，每个作业有不同的时间长度和紧急程度，超过时间会
最新发布
10-06
基于matlab的作业调度问题。 采用遗传算法，解决作业调度问题。 一共三个作业，每个作业有不同的时间长度和紧急程度，超过时间会有惩罚措施。 通过遗传算法计算出最好的作业安排，使得惩罚最小，获益最大。 最终结果通过GUI用甘特图的方式展示出来。 更根据订单需求和时间需求匹配自己的情况。 程序已调通，可直接运行。
opencv图像处理实例编程
10-06
opencv图像处理实例编程
run nian 12345678.exe
10-06
run nian 12345678.exe
python连接数据库
05-24
# 创建数据库连接 cnx = mysql.connector.connect(user='root', password='password', host='localhost', database='test') # 创建游标对象 cursor = cnx.cursor() # 执行 SQL 查询 query = ("SELECT id, name ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值