开发者

Remote connect to mysql?

I don't use php or mysql but I am trying to upgrade a phpbb board I got but the one click install开发者_开发技巧er forgot to install some stuff in the database so I can't upgrade to the newest version till I add the missing stuff.

So I need to do a remote connect to mysql database but I am not sure how to do this or what software I need(free, and very easy to setup I don't want to spend much time on this).

I don't really want to use phpmyadmin since I don't want to start setting up a virtual directory and whatever else it needs to be installed. Like I said I don't do php or mysql I just choose it since in my hosting package it was one click to install phpbb and I had a mysql database free.

Thanks


You could use the trial version of Navicat or SQLyog


First, you need to verify that your host allows external connections to the database. Once you've done that you can add a MySQL user that can connect from outside, then use something like MySQL Administrator or crunchyfrog to connect and operate.


MySQL Workbench Download

GUI tool that should do everything you need.

Previous link was for the download, here is the product page for more info:

MySQL Workbench Documentation


Regarding connectively to mysql here are some things to look out for that sometimes may inhibit you from connecting remotely. Depending on how you installed it you may not be able to connect remotely at all...

bind_address set to 127.0.0.1 skip_networking option set to true

With either of these configurations above you'll only be able to connect from the local machine.

In order to verify that mysql is actually listening for remote connections you can try:

telnet host 3306

If it connects then you can connect and you can probably figure out the rest from there.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜