84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
比如我在公司电脑上用Apache建的数据库,能不能在宿舍的电脑上连接?公司这台电脑的mysql是不是必须要开启才能连接?
光阴似箭催人老,日月如移越少年。
mysql needs to be set to allow remote connectionsmysql>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
Check whether your company’s computer database provides external network access
Under authorization, add local authorization to the LAN IP address you want to connect to the other party
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
Check whether your company’s computer database provides external network access
Under authorization, add local authorization to the LAN IP address you want to connect to the other party