Navicat 连接远程数据库 出现SQL Error (2013): 解决方法

china0396

解决方法：

修改MySQL数据库配置文件etc/my.cnf
5 I/ j' g) A" f, d1 l
+ g. S# q0 c3 y& z8 H' r在[mysqld]最下面添加
  J: _: V' h( J
skip-name-resolve
. v+ r/ w! a* [! D. R. `# I
# For advice on how to change settings please see  
# http://dev.mysql.com/doc/refman/ ... ation-defaults.html   
2 h- a1 ?7 Q4 W4 X8 A$ |( l[mysqld]  
#  
# Remove leading # and set to the amount of RAM for the most important data  
: a; s, f6 y" H/ C7 P! y+ L# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.  
( x4 L2 B- `6 ?' a5 t! A; K# innodb_buffer_pool_size = 128M  
+ k) R. f/ ^& F5 d#  
$ {- \7 s; s" }3 v6 [# Remove leading # to turn on a very important data integrity option:
logging  
1 B- O) `7 b2 }! F# changes to the binary log between backups.  
# log_bin  
% c+ x1 j' P8 L. w( J2 L#  
# Remove leading # to set options mainly useful for reporting servers.  
# The server defaults are faster for transactions and fast SELECTs.  
3 ]% \* X% S4 W# Adjust sizes as needed, experiment to find the optimal values.  
% z# s, C# ^4 B8 i8 f# join_buffer_size = 128M  
# sort_buffer_size = 2M  
6 g2 o& d3 \5 x. O! s# x- X* g# read_rnd_buffer_size = 2M  
2 }, E9 c" ^9 f+ Pdatadir=/var/lib/mysql  s
) B7 W+ x9 P) R* i6 Y" J0 ~1 n) Qocket=/var/lib/mysql/mysql.sock   
# Disabling symbolic-links is recommended to prevent
assorted security risks  
symbolic-links=0   
9 p( r4 Q" u7 P& Z# Recommended in standard MySQL setup  
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES   
; D2 R3 I& ^: P2 f4 {6 b; Gmax_allowed_packet      = 32M  
max_connections         = 1000  
# g: C! |5 R9 r4 umax_connect_errors      = 2000  
skip-name-resolve  
[mysqld_safe]  
log-error=/var/log/mysqld.log  
pid-file=/var/run/mysqld/mysqld.pid
然后重启MySQL服务

! a+ C  ^  E8 a/ y, X) \: }service mysqld restart
4 t7 v( I9 R& N3 |# S7 J/ i( u  I+ N