[教程/工具] Navicat 连接远程数据库 出现SQL Error (2013): 解决方法

解决方法：" D7 O/ J' Q+ F1 N- C" @

5 d* I% v4 b! V! X修改MySQL数据库配置文件etc/my.cnf
/ R% }8 k7 u1 ]3 |' C8 s
8 n- s# t. e; f* G4 f  i) g3 ?; m$ c在[mysqld]最下面添加
! B9 G" O5 I! }8 w. B
, M+ r5 S( c9 S$ i9 h' L* nskip-name-resolve
) M8 M, S  h$ A0 N8 [
( M  u9 n+ }! v2 ]  S# For advice on how to change settings please see  - E( @8 M* [; k( o2 _
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html   
/ k3 S0 _$ E" M9 h[mysqld]  
" r) r7 _* _! u9 v" m#  
& M* L6 ~* U' e1 M% ~# b* y) o# Remove leading # and set to the amount of RAM for the most important data  
- ~6 \$ }# B" L9 K5 V' x% Q# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.  
8 I7 R' U: `6 K6 g/ M8 A+ e" [# innodb_buffer_pool_size = 128M  - D2 e; x: u+ W2 l3 J. x* b
#  , G; {' h% j. h7 c: O
# Remove leading # to turn on a very important data integrity option:
6 j0 t# L8 M& p3 y" vlogging  : ?7 l/ {  n* @7 Q, w/ S' v$ A. V
# changes to the binary log between backups.  ) d' L8 }3 m; v4 P/ y7 U7 G
# log_bin  
& ], `! R  _! P- G3 q#  0 M# P% G2 o( z  {
# Remove leading # to set options mainly useful for reporting servers.  
) c$ P. c' A2 {# The server defaults are faster for transactions and fast SELECTs.  
* r8 ~" d* u  D: k5 j# g/ }) _# Adjust sizes as needed, experiment to find the optimal values.  1 K7 y8 `/ L3 j  g8 C& N8 H
# join_buffer_size = 128M  
) Z" Z% Q6 {3 _! W/ l# sort_buffer_size = 2M  0 e8 B4 ^  y4 J. f8 o: F  t3 c; _% D/ w8 P
# read_rnd_buffer_size = 2M  
" L! x0 Q, x! b8 v. F- g) Zdatadir=/var/lib/mysql  s$ i2 g" @) X/ x7 b3 C3 {$ }. p& ]& X
ocket=/var/lib/mysql/mysql.sock    6 M' o* s7 H' c1 V
# Disabling symbolic-links is recommended to prevent 2 f$ l7 w; ]2 x$ H
assorted security risks  
; i# y9 s2 C* }symbolic-links=0    ) L4 e6 o; a% W
# Recommended in standard MySQL setup  
9 i+ [) y" N+ [5 D) @) }3 @#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES   3 U# p) Q  r6 n2 l& y7 F! T3 D: O
max_allowed_packet      = 32M  ' S/ d1 H! x$ J
max_connections         = 1000  $ M+ ^/ |3 y1 L& s5 f- q- Y
max_connect_errors      = 2000  
; G- R0 H. s; W! dskip-name-resolve  6 B& m. t9 o7 i1 U7 h6 ^5 W" u4 z
[mysqld_safe]  " X' \" r! x' U% e9 V
log-error=/var/log/mysqld.log  0 I- G+ ]5 ^- ]( G/ b) n( T3 o
pid-file=/var/run/mysqld/mysqld.pid
2 R9 y. U( f7 |4 T" s1 X然后重启MySQL服务% s, \- X5 d, x/ W' S
0 e4 n9 G- }. V, j. a% `
service mysqld restart4 K0 W. D$ o! Q' n8 f! r, P& ?

- `; T+ u0 s6 L  {0 ~% ^0 e$ ?  P