Connecting To Astahost's Mysql

sparkx

Sep 30 2007, 12:50 AM

Now this topic could fit under lots of subforums but this isn't really a programming question but rather asking what asthosts mysql host is?
Long story short I need to connect to a mysql database via c++ (I dont even know if that is possible) but I cant use localhost (for obviouse reasons). Could you tell me how to find the mysql host for my account?
Thanks,
Sparkx

Comment/Reply (w/o sign-up)

Sten

Sep 30 2007, 12:55 AM

its localhost. i use localhost for everything on astahost anyway that needs installing with a database.

Comment/Reply (w/o sign-up)

Jimmy89

Sep 30 2007, 08:41 AM

I am assuming that you are making a stand-alone program for the computer and will not be making something hosted at astahost, the only thing you are hosting is the database. You program will go online to get the database info.

the ip address for my website (I think it is a shared ip we all use) is 64.69.46.210 - i think you should be able to connect to that.

Comment/Reply (w/o sign-up)

.:Brian:.

Sep 30 2007, 08:04 PM

Yes, you should be able to use the shared IP address, but then you are also going to have to go into your cPanel and change a few things around....

You'll have to find the thing about who is allowed to connect, and change it so that your IP address is allowed (otherwise the MySQL server will not accept your connection)

Comment/Reply (w/o sign-up)

Jimmy89

Oct 1 2007, 12:31 AM

Brian is correct, at the moment the MySQL server will only accept connections from localhost or 192.168.1.% (Where % is the wildcard). Hopefully you have a static IP address that you are going to use, otherwise you might have some trouble connecting.

You can also use a wildcard if you know which range your IP address it going to be in, that just means that you would be letting other people with a 'similar' IP to connect (not that they could without username and password).

I think you should be able to enter just the wildcard (%) as the allowed host, but that lets everyone that has an IP address access to your mySQL server (thats a lot of people), but there will only be a limted amount of people that know where it is exactly, and only you are going to know the username password for it.

To change your 'allowed hosts' goto your CPanel > Site Management Tools > mySQL Databases > Access Hosts and add a new value into the box there.

Good Luck,
-jimmy

Comment/Reply (w/o sign-up)

xboxrulz

Oct 1 2007, 03:21 AM

Make sure you follow Jimmy89's suggestion (I don't know for sure either). Then, connect via the shared IP address for the Gamma server at 64.69.46.210. Be sure to connect to port 3306 (MySQL default port number).

xboxrulz

Comment/Reply (w/o sign-up)

ethergeek

Oct 1 2007, 08:02 PM

I'd say your best bet would be to just enable access to % and choose a good, STRONG password, then remove that account's % access location when you aren't going to be working with it for awhile.

Might also want to let the site admins know so that they don't think that your violating the TOS by using the SQL databases as storage for another site (I'm not sure if this violates the TOS or not, but when doing something nonstandard and/or unexpected like this, it's generally a good idea to let the sysops know ahead of time what you're doing).

Comment/Reply (w/o sign-up)

.:Brian:.

Oct 3 2007, 11:23 PM

Yes, I would also recommend that you e-mail support about this....

Because you don't want to end up getting your account terminated due to usage that is against the TOS...you never know what they may or may not allow you to do..so it is always best to just ask them...they'll get back to you quickly, and it'll save the hassel of having your account deleted and you getting upset, if you know in advance whether or not it is ok or not.

Comment/Reply (w/o sign-up)

xboxrulz

Oct 4 2007, 02:25 AM

Just as long as you don't use the Astahost account as some type of storage-only account, then you should be fine. There hasn't been something specific that had been said about not allowing remote connection to MySQL*. Heck, some standalone programs people write tells it to store things into a remote MySQL database.

* don't quote me on it. Be sure to double check with an administrator.

xboxrulz

Comment/Reply (w/o sign-up)

Similar Topics

Keywords : Connecting Astahost39s Mysql

Mysql Connect Error, Too Many Connections. - (1)
Just to begin with I want to say that I am not here necessarily to complain about it lol. I'm
not sure but if my site is possibly helping to contribute to the problem, I'd like to know if
anyone knows any good articles or tutorials that might have information on what to look out for that
could contribute to these sort of problems. I know my site may not have anything to do with it (as
I don't think it is overly popular or anything or even close), but knowing what to look out for
when messing with PHP/mySQL would be great. I personally haven't found too...

Mysql Server Not Stable After Hard Disk Swap On April 6th - (2)

Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql - (3)

Hi all, Please help me! My site was working fine! ( www.fun.niranvv.com ) But now, its showing
one error message as: Warning: mysql_connect() : Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) in
/home/niranvv/public_html/fun/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is
not a valid MySQL-Link resource in /home/niranvv/public_html/fun/db/mysql4.php on line 330 Warning:
mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/niranvv/public_html/fun/db/mysql4.php on line...

What Is The MySQL Version @ Asta ? - MySQL 4.0.26-Max
(16)

Hi, A few question here, 1. Just wondering, the MySQL hosted on astahost.com is actually version
"4.0.26-Max" according to phpmyadmin. But why is cPanel showing "4.1.21-standard"? 2. Actually
i've existing codes that need function introduced after version 4.1.1, is there by any chance
astahost or xisto is going to upgrade the MySQL package? Thanks...

Problem With MySQL - (5)

I tried to visit my website today and I recieved the dreadful page from my php-nuke site "There
seems to be a problem with the MySQL database" First I thought, "no big deal server is probably
rebooting or down for a little bit" So i logged into my cpanel and clicked on "Server Status".
Thats when I started worrying. It said the MySQL servers were up and runnign fine. I went back to my
main page and looked at my MySQL server count and instead of saying 2/99 it now says NA/99 I am
unable to create a new database and I recieve this error when I click on PHPmyadmin QUO...

Php And Mysql Version. - (7)

Is there any plan to upgrade or see if it can be upgraded to PHP5 and mySQL5 in the future?...

Mysql Error Never Seen On My Site Before (too Many Connections). - (13)

I just tried to visit my site to see if anything had changed on my forums and such and I got this
message: Warning: mysql_connect(): Too many connections in /xxxx/xxxxx/xxxxxx_xxxxx/xxx/xx_xxxx.php
on line 7 Error! Could not connect: Too many connections. I have never recieved this error before,
does this mean someone is mucking with my site somehow??? The particular php file it mentions is
the one that defines variables like db username etc and connection to the site's database that I
include wherever it is needed in various file for the site. EDIT: I managed t...

Help Me! - Frontpage & phpBB with MySQL (3)

I was just approved an Astahost account with the starter package. I explored the Cpanel a bit
and have got the following problems : 1.Frontpage Extensions The Cpanel states that the
Frontpage Extensions have been installed. But when I uploaded my site on frontpage at
"ftp://ftp.mysitename.astahost.com/public_html/" it stated an error that Fronpage Extensions are not
installed on this server! When I opened my site online, I can see the page, but I cannot see any
graphics/images! Also, my forms and other stuff isn't working either. Please help me out and let
me...

Weird MySQL Message - (4)

wenever i assign priviledges to a MySQL databases, it seems to work properly but this message is
always there QUOTE bitshift_wforumu (Privileges: ALL PRIVILEGES) Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:bitshift_wforum:localhost","bitshift_wforumu"," ");
PHP $dbh=mysql_connect ("localhost", "bitshift_wforumu", " ") or die ('I cannot connect to the
database because: ' . mysql_error()); mysql_select_db ("bitshift_wforum"); My database
name is: bitshift_wforum the username is: bitshift_wforumu What does all that maen, it ...

Problem With MySQL Not Being Able To Connect - Anyone know the reason for this error... (9)

Hello everyone, Im currently having a problem with mySQL, I wrote a PHP login script that
doesnt seem to be working for some reason. I created a database and everything looks correct, is
this a server issue or is the issue related to my script? But anyway this is my error, hope someone
can help Ive tried to search forum for answer but none of the posts seems to answer my question:
QUOTE Warning: mysql_connect(): Host 'gamma.xisto.com' is not allowed to connect to this
MySQL server in /home/hp2001/public_html/ucscKGD/checklogin.php on line 10 cannot co...

MySQL - Can't Connect - Cristal Report (1)

From http://thoaionline.com (hosted by Astahost) QUOTE Warning: mysql_connect(): Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/pheart/public_html/thoaionline/includes/database.mysql.inc on line 31 Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) In cPanel Mysql
databases 0 / 99 But I have 5 MySQL databases in my account (maybe more). All of them become
unusable now. Some more messages from http://website.thoaionline.com QUOTE Warning:
mysql_pc...

Can I Access MySQL Database From Outsite, Directly - (10)

I'm going to make an OFFLINE FORUM. So I want to know is that possible or not. My paid host
don't allow that. How about astahost?...

MySQL Database - Important Report (3)

I'm writing this to report about a error. One of my mySQL database has been droped and my site
stop working. I don't know the reason. I'm hosted on gamma server. I think you (admin)
should check it. PS: One of my paid hosting provider also met this problem a few day ago....

IPS Driver Error / MySQL Database - What in the world? How is this possible? (1)

Just several hours ago, I couldn't access my website/forum because of some error with an SQL
socket or something like that. I need desperate help because I don't want to reformat everything
again. Well, here is what comes up: IPB WARNING mysql_connect(): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (Line: 114 of
/ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can
try to refresh the page by clicking here. Error Returned: SQL error: Can't connect to local
M...

General Problems With New Account - MySQL problems and quota issues (2)

I just got a new account and CPanel reports that I have -380.2 MB of quota space and using 400.2MB.
This disables some of Cpanel's functions. It would have been nice to use the automated Mambo
installer, but no biggy. I uploaded the latest Mambo .tar.gz from my FTP program and unpacked it
via Cpanel's file manager with no problem. When I first logged into the system I created a new
Database for mambo and a new user for that database and linked the two from Cpanel. I logged off to
watch something on TV and came back and that database isn't being reported...

Problem With Mysql - Cannot connect to database.... (6)

Hi, this is the first time after I got my hosting to try and use MySQL. My site is
http://abhiram.astahost.com . I created a user in CPanel -> 'MySQL Databases' as root. So,
the new user created will be 'abhiram_root'. Similarly I created a database called
'webpage' (which changes to 'abhiram_webpage'). I set up the database and the tables
using phpMyAdmin and uploaded the files after making changes to the user name and the database. But
it's not opening the database. It's connecting to MySQL without any problems, but it
isn'...

Mysql Error - (5)

Hey i got this error trying to install something on my database CODE mysql error: 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 'rpg_class` (`name`, `folder`, `regatt`, `magicatt`, `magicdef` mysql
error number: 1064 can anyone tell me what this means or how i fix it?? thanks in advance...

MySQL Errors? - Error 13! - (0)

Recently been attacked by "Can't create/write to file '/tmp/#sql_28e2_0.MYI' (Errcode:
13)"? Then its a simple fix, please DELETE (backup first) your SOURCE files that talk to the MySQL
database, and re-upload them This will purge them from the system and force them to recreate the
temporary files. Do NOT delete your database, just backup your files, delete them, re-upload them
and youll be fine. This is due to MySQL crash. Easily fixed and no data has been lost. Sorry guys
Details: MySQL crashed while writing data, it seems the temporary file has bee...

Looking for connecting, astahosts, mysql