为了远程连接你必须有MySQL绑定端口：3306到你的机器IP在/etc/mysql/mysql.conf.d/mysqld.cnf然后你有在本地主机和“%”通配符中创建用户并授予对所有数据库的权限。见下文：将xxx替换为你的IP地址（通常为0.0.0.0）bind-address=xxx.xxx.xxx.xxxthenCREATEUSER'myuser'@'localhost'IDENTIFIEDBY'mypass';CREATEUSER'myuser'@'%'IDENTIFIEDBY'mypass';ThenGRANTALLON*.*TO'myuser'@'localhost';GRANTALLON*.*TO'myuser'@'%';根据您的操作系统，您可能必须打开端口3306以允许远程连接.restartmysql服务：sudosystemctlrestartmysql
