Mysql 错误难点汇聚(不断更新中卡塔尔

1、Mysql errono 1005 : 主外键不是完全大器晚成致 , 请检查如下几点:
a、字段是或不是留存 b、类型是或不是意气风发律(注意unsigned , powerdesign 生成难题卡塔尔国c、数据库引擎是或不是生机勃勃致 d、字符编码是不是相近e、windows平台投注意改过lower_case_table_names = 0,
windows本人不区分文件大小写,改为0之后就分别了大概导致找不到引用的表
2、Mysql errono 121: 外键节制名称再度 3、记录 Mysql WorkBench
中单词缩写意义:
PK: primary key (column is part of a pk) NN: not null
(column is nullable) UQ: unique (column is part of a unique key) AI:
auto increment (the column is auto incremented when rows are inserted)
BIN: binary (if dt is a blob or similar, this indicates that is binary
data, rather than text) UN: unsigned (for integer types, see docs:
“10.2. Numeric Types”) ZF: zero fill (rather a display related flag, see
docs: “10.2. Numeric Types”) 4、mysql 权限设置
//增多远程主机访谈MYSQL root权限 insert into user(host,user,password卡塔尔国values(‘%’,’root’,PASSWORAV4D(‘root’State of Qatar卡塔尔; //root 权限授权 grant all
privileges on *.* to ‘root’@’%’ identified by ‘root’ with grant
option; //更新权限设置 flush privileges; 5、防火墙设置 //打初阶口
/sbin/iptables -I INPUT -p tcp –dport 3306 -j ACCEPT //保存
/etc/rc.d/init.d/iptables save //查看状态 /etc/init.d/iptables status
6、开机自动运转(落成近似Windows服务卡塔尔 /sbin/chkconfig –level 2345
mysqld on /sbin/chkconfig –list 结果如下: mysqld 0:off 1:off 2:on 3:on
4:on 5:on 6:off

[intrinsic column flags] (基本字段类型标志卡塔尔国

– PK: primary key (column is part of a pk) 主键

– NN: not null (column is nullable) 非空

– UQ: unique (column is part of a unique key) 唯一

– AI: auto increment (the column is auto incremented when rows are
inserted) 自增

  www.2cto.com