PremiumSoft Navicat Lite 8.2 connect to mysql

 

Setup connection

1st connect fail cause error 1130

Allow root user can remote connect

Local connect to MySQL via command line and add new user@remote hosts

mysql mysql -uroot –p
mysql>insert into user values
('%','root',password('123'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'
,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'
,'Y','Y','Y','Y','Y','Y'
,'','','',''
,0,0,0,0);
mysql>flush privileges;
mysql> select host, user from user ;

2nd connect ok