alter table on host computer.

[SH100]

Hi,

I am working on hosting server, I want to alter table on that server(administrator have given me right to modify table design).

I tried phpmyadmin but not working. What other tools can i use?

1. Do I have to download phpmyadmin on my local machine or sever administrator has to do it?

I read somewhere that phpmyadmin is web based tool so will it be on my local computer or I will be simply accessing url on hosting server?

2. Which file exactly I have to download to work on windows?

3.Any step by step tutorial about it?

4. I have php & mysql or local computer but it's not configured properly so does phpmyadmin is trying to connect to local MySQL / php but I want it to help me to modify remote table.

5. Is alter table query possible with linked microsoft access database (incase phpmyadmin didn't work for me.)

Thank you.

[aussie girl]

If your hosting server has a database, then normally they would have tools to edit it on their servers. Do they PhpMyAdmin as an installation option?

[NightShift58]

If nothing else helps, you can write a PHP script that will do it for you, using:

mysql_query("ALTER TABLE xxx ... etc")

[MrCoder]

Worth a try, Navicat (http://www.navicat.com/)

[NightShift58]

If you want to go that route, try SQLyog as well.

Navicat and I never got friendly.

[SH100]

NightShift58 's idea to fire query from PHP worked for me.

Thank you everybody for your response.

[MrCoder]

Navicat just came out with a new version, but I'll have to give SQLyog a go before I look at upgrading.