Uploading your MySQL database and using it

[jagger]

Hello,

I am new to this so sorry if some questions seams silly to you
I am developing some application in C# where I use MySQL database (filled with data) from local PC. Now I want to try to upload that database to Free Web Hosting with PHP, MySQL and No Ads and connect to it with my program.
My 1st question is how can I upload MySQL database from my PC to server?
I suppose that I need somehow to upload Dump20111205.sql file (created in MySQL workbench) to server.
My 2nd question when I upload database what are parameters for connecting to it?

[Modestas]

Hello,

Firstly you will need to create MySQL database in DirectAdmin control panel. After that you will get MySQL username and password. To access your database from your PC, you will need to add your IP address in the Access Hosts that can be found by clicking on your database.
To connect to the database, you will need to use MySQL username, password and port 3306.

[jagger]

Thanx for replay

Steps are:

To create database:
Control Panel > MySQL Management > Create new Database
To fill data:
Control Panel > MySQL Management > phpMyAdmin > Import > Choose File (dumb file exported by MySQL Workbench)
Note: Database name on your PC (that you exported) must be the same as name created here.

Now I have questions, again

you will need to add your IP address in the Access Hosts that can be found by clicking on your database.

If I do that only I, with my IP address will be allowed to access it?
I need to set that ever1 that have username and password can access that database (no matter what IP adress he have).

To connect to the database, you will need to use MySQL username, password and port 3306.

Where can I find my database address for connection?

[Modestas]

Only IP addresses that is added to access hosts can connect to remote database.

Use server hostname, for example, box1.host1free.com or server IP 94.249.143.2 (IP depends on box number).

[jagger]

Only IP addresses that is added to access hosts can connect to remote database.

Use server hostname, for example, box1.host1free.com or server IP 94.249.143.2 (IP depends on box number).

Hm... that is problem cos you get dynamic IP address from provider

[Modestas]

You mean your IP is dinamic ? In this case it's not possible to have remote database access.