MySql question

[pitospir]

Hi,
I'm interested in buying a site (baby plan) and I'd like to ask something about mysql.
Having my databases hosted in your servers is it possible to access them remotely from any other pc? I don't mean through cpanel. I mean using an application like "mysql administrator" or even writing an application myself that connects to my databases.

Assuming that DNS will give me the ip, what would be the port for the connection string.

In general, can I to connect my databases remotely?

[GvilleRick]

Yes, it is possible to connect to the database. You would set up a Remote Host IP in cPanel to allow it to connect using the default port of 3306.

[generay]

Hello, Im setting up a database. Im stuck getting this error below..cant seen to find anything wrong in my script. I have a feeling Im getting the "localhost" part incorrect..why is that simple step so tricky.

Can I please get some help with this?? thank you
Gene


MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php

$MySqlHostname = "localhost"' at line 1

[slapshotw]

Did you put a semicolon after the line? (Just making sure the simple stuff is covered).

Also, it seems like the "<?php" is being used as part of a query. Can you give us more lines of the file, above and below it?

[generay]

Hey, I really appreciate you looking at my php. Its posted below and Ive edited the user and pass.
Thanks a heap..

Gene


<?php

$MySqlHostname = "localhost"; //the name of your host - if its local leave it as is.
$MySqlUsername = "txxxx_xxxe"; //the username to your database.
$MySqlPassword = "pxxxxx"; //the password to your database.
$MySqlDatabase = "txxxxx_xxxxxd"; //the name of your database.


// do not edit below this line!!
///////////////////////////////////////////////////////////////////////

$dblink=MYSQL_CONNECT($MySqlHostname, $MySqlUsername, $MySqlPassword) or die("Could not connect to database");
@mysql_select_db("$MySqlDatabase") or die( "Could not select database"); ?>

[slapshotw]

Is this file getting called as an include from another file?

[generay]

Originally Posted by slapshotw

Is this file getting called as an include from another file?

Its called connect.php for an advertising exchange script.. Its the file that creates a table. I am at the step where it runs sql so now it calling out a line one error...Ive double checked everything.

Gene

[slapshotw]

If you want PM me, I don't want to have all the back and forth here on the thread--let me help you try to fix it and then we'll post the resolution.

[generay]

Originally Posted by slapshotw

If you want PM me, I don't want to have all the back and forth here on the thread--let me help you try to fix it and then we'll post the resolution.

Thanks...

[pitospir]

Originally Posted by GvilleRick

Yes, it is possible to connect to the database. You would set up a Remote Host IP in cPanel to allow it to connect using the default port of 3306.

Thank you for the info!