Executing SQL Script for mySQL

[shalom_m]

1. How can I run an SQL script to define a number of tables form c-panel?

2. How can I connect form a program on my PC to the remote DB from through the IP?

[justoneguy]

1. How can I run an SQL script to define a number of tables form c-panel?

2. How can I connect form a program on my PC to the remote DB from through the IP?

1. Use phpMyAdmin to upload the sql file and execute it.

2. Depends a lot on the program, but you will definitely need to enable access to outside hosts on the database Just add % to the allowed hosts on the manage databases screen. A little more information would help be more specific (is it a program that will require an odbc driver? is it a local php script, etc.)

[Buddha]

2. How can I connect form a program on my PC to the remote DB from through the IP?

Kylec has a FAQ on tunnelling: http://forums.dathorn.com/showthread.php?t=216