Mysql Error issue rollup (in constant update) _mysql

1, Mysql Errono 1005: The primary foreign key is not exactly the same, please check the following points:

A, whether the field exists
b, the type is consistent (note unsigned, powerdesign generation problem)
C, the database engine is consistent
D, character encoding is consistent
E, the Windows platform Note modified lower_case_table_names = 0, Windows itself is not case-sensitive, to 0 after the distinction may cause the reference can not find the table

2, Mysql Errono 121: FOREIGN KEY constraint name repeat

3, the record Mysql WorkBench word abbreviation meaning:
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 the is binary data, rather than text)
un:unsigned (for integer types, docs: "10.2. Numeric Types ")
Zf:zero Fill (rather a display related flag, docs: "10.2. Numeric Types ")

4, MySQL permission settings
Add remote host access MySQL root permissions
Insert into User (Host,user,password) values ('% ', ' root ', password (' root '));
Root Rights authorization
Grant all privileges in *.* to ' root ' @ '% ' identified by ' root ' with GRANT option;
Update permission settings
Flush privileges;

5, firewall settings
Open port
/sbin/iptables-i input-p TCP--dport 3306-j ACCEPT
Save
/etc/rc.d/init.d/iptables Save
View status
/etc/init.d/iptables status

6, on the automatic operation (to achieve similar Windows services)
/sbin/chkconfig--level 2345 mysqld on
/sbin/chkconfig--list
The results are as follows:
Mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off