Question

navicat for mysql运行不了.sql文件

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?xml version="1.0" encoding="UTF-8"?>
<Connections Ver="1.1">
<Connection C' at line 1
[Err] <?xml version="1.0" encoding="UTF-8"?>
<Connections Ver="1.1">
<Connection ConnectionName="本地" ConnType="MYSQL" OraConnType="BASIC" Host="localhost" Port="3306" Database="" OraServiceNameType="SERVICENAME" TNS="" MSSQLAuthenMode="SQLSERVER" DatabaseFileName="" UserName="root" Password="5658213B" SavePassword="true" SettingsSavePath="C:\Users\joan chao\Documents\Navicat\MySQL\servers\本地" Encoding="65001" Keepalive="false" KeepaliveInterval="240" MySQLCharacterSet="true" Compression="false" AutoConnect="false" NamedPipe="false" NamedPipeSocket="/tmp/mysql.sock" OraRole="DEFAULT" OraOSAuthen="false" SQLiteEncryption="false" MSSQLEncryption="false" UseAdvanced="false" SSL="false" SSL_Authen="false" SSL_PGSSLMode="REQUIRE" SSL_ClientKey="" SSL_ClientCert="" SSL_CACert="" SSL_VerifyCACert="false" SSL_Clpher="" SSL_PGSSLCRL="" SSH="false" SSH_Host="" SSH_Port="22" SSH_UserName="" SSH_AuthenMethod="PASSWORD" SSH_Password="" SSH_SavePassword="false" SSH_PrivateKey="" HTTP="false" HTTP_URL="" HTTP_EQ="false" HTTP_PA="false" HTTP_PA_UserName="" HTTP_PA_Password="" HTTP_PA_SavePassword="false" HTTP_CA="false" HTTP_CA_ClientKey="" HTTP_CA_ClientCert="" HTTP_CA_CACert="" HTTP_CA_Passphrase="" HTTP_Proxy="false" HTTP_Proxy_Host="" HTTP_Proxy_Port="0" HTTP_Proxy_UserName="" HTTP_Proxy_Password="" HTTP_Proxy_SavePassword="false"/>
</Connections>
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Answer 1

（1）新建一个数据
（2）右击所建的数据库，点击运行sql文件
（3）文件里选择要运行的sql文件
（4）显示运行成功，加载成功。