duanmei1536 2015-10-05 12:14
浏览 293

如何在ubuntu上将MySQL主机设置为“localhost”以外的其他东西？

I have two server bought and I have 2 real IP's. One for files and another for database. I setup mysql database to second server but I cannot connecting it from my first server because mysql hostname is localhost. How can I connect 2nd server database from first one?

  • 写回答

2条回答 默认 最新

  • douchao1879 2015-10-05 12:15
    关注

    Use the IP Address of the Database server as the host name

    i.e 

    host = '192.168.1.10`;

    you will of course also have to make sure you are using a MySQL user account that is allowed to login from your applcation servers ip address

    评论

报告相同问题？

悬赏问题

  • ¥15 深度学习根据CNN网络模型，搭建BP模型并训练MNIST数据集
  • ¥15 lammps拉伸应力应变曲线分析
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热（温度不同）的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛
  • ¥15 请问Lammps做复合材料拉伸模拟，应力应变曲线问题
  • ¥30 python代码，帮调试，帮帮忙吧
  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建