ããNavicat Premium æ¯ä¸ä¸ªå¯å¤éè¿æ¥çæ°æ®åºç®¡çå·¥å
·ï¼å®å¯ä»¥åä¸ç¨åºåæ¶è¿æ¥å° MySQLãOracleãPostgreSQLãSQLite å
sql server æ°æ®åºï¼è®©ç®¡çä¸åç±»åçæ°æ®åºæ´å æ¹ä¾¿ãNavicat Premium ç»åäºå
¶ä» Navicat
æåçåè½ãæäºä¸åæ°æ®åºç±»åçè¿æ¥è½åï¼Navicat Premium æ¯æå¨ MySQLãOracleãPostgreSQLãSQLite å SQL
Server ä¹é´ä¼ è¾æ°æ®ãå®æ¯æ大é¨ä»½ MySQLãOracleãPostgreSQLãSQLite å SQL Server çåè½ã
ããnavicatå¦ä½è¿æ¥mysqlï¼
ãã1ãé¦å çµèä¸å¿ é¡»å®è£ äºmysqlçæ°æ®åºãï¼å¦æä¸æ¸ æ¥èªå·±æ¯å¦å·²ç»å®è£ æåmysqlï¼å¯ä»¥å¨å¼å§èåè¾å ¥âmysqlâï¼è¿è¡æç´¢ï¼
ãã2ãæå¼Navicat for Mysql ï¼è¿éä¹å¯ä»¥ä½¿ç¨ä¸é¢çæ¹æ³ï¼å¨å¼å§èåæç´¢æ¡ä¸è¾å ¥ânavicatâï¼
ãã3ãæå¼ååæºå·¥å ·æ 左边第ä¸ä¸ªâconnectionâï¼è¿å ¥è¿æ¥é¡µé¢ã
ãã4ãæéè¦çä¸æ¥ï¼æå¼ççé¢æäºä¸ªæ¡éè¦è¾å ¥ï¼
ãã第ä¸ä¸ªï¼connection Name éè¦è¾å ¥çæ¯æ°å»ºçè¿æ¥ççååï¼è¿éå½å为âæ¬å°âï¼
ãã第äºä¸ªï¼Host Name/Ip Address éè¦è¾å ¥çæ¯æ¬æºçipå°åæè ç´æ¥è¾å ¥âlocalhostâ,è¿ééæ©ç¬¬äºç§ï¼
ãã第ä¸ä¸ªï¼Port ,è¾å ¥ä½ å®è£ æ¶åç端å£å·ï¼ä¸è¬ä¸ºé»è®¤ç3306ï¼
ãã第å个å第äºä¸ªåå«ä¸ºï¼UserNameåPassword,ææ为éè¦è¾å ¥ä½ æ°æ®åºåç¨æ·ååå¯ç ï¼
ããæåæä¸é¢é£ä¸ªâSave Passwodâçå°æ¡æ¡ç»å¾ä¸ã
ãã5ãå®æä¸é¢æ¥éª¤ï¼ç¶åç¹å»å·¦ä¸è§æ个âTest Connectiionâå¦æå¼¹åºsuccessï¼ç´æ¥ç¹å»å³ä¸è§çâsaveâæé®å°±å¯ä»¥äºãå¦æå¼¹åºerror ï¼åéè¦åéæ°ä»ç»æ¥çä¸è¿°æ¥éª¤åªéå¡«éäºã
ãã6ãç¹å»âsaveâåï¼å°±å¯ä»¥åå»âæ¬å°âï¼è¿éçâæ¬å°âæ¯åæè¾å ¥çconnection Nameï¼ï¼ç¶åå°±å¯ä»¥æå¼æ°æ®åºäºã
mysql数据库的安装与Navicat远程连接 Java后端集成开发环境配置