怎么用navicat for mysql连接别的电脑的数据库？

Question

比如我在公司电脑上用Apache建的数据库，能不能在宿舍的电脑上连接？公司这台电脑的mysql是不是必须要开启才能连接？

Answer 1

mysql needs to be set to allow remote connections
mysql>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
But here you'd better not use root, you can create a new one Ordinary users come to visit

Answer 2

Check whether your company’s computer database provides external network access

Answer 3

Under authorization, add local authorization to the LAN IP address you want to connect to the other party