我已经成功地在Linux中安装和配置了postgresql,
1. postgres user created
2. new db created successfully
3. I'm trying to connect using pgadmin III (Windows)
4. Following details are adding in pgadmin window
Host: DEMO
Host: XXXX
Port: 5432
Maintenance DB: postgres
Username: postgres
password: G0!mf17.
5. Click
我找了很多东西,但没能解决那个问题。我能够访问运行在不同windows机器上的MySQL服务器。我已经采取的步骤是
将my.ini文件绑定地址更改为0.0.0.0
创建用户并由GRANT ALL PRIVILEGES ON DATABASE.* TO user@'%' IDENTIFIED BY 'password';授予权限
从命令行到windows MySQL server mysql -h windows server ip -u user -p
它工作得很好,在MySQL工作台上,我可以从我的机器连接到windows MySQL服务器